The Definitive Guide to DAX


Book Description

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio




Successful Business Intelligence: Secrets to Making BI a Killer App


Book Description

Praise for Successful Business Intelligence "If you want to be an analytical competitor, you've got to go well beyond business intelligence technology. Cindi Howson has wrapped up the needed advice on technology, organization, strategy, and even culture in a neat package. It's required reading for quantitatively oriented strategists and the technologists who support them." --Thomas H. Davenport, President's Distinguished Professor, Babson College and co-author, Competing on Analytics "When used strategically, business intelligence can help companies transform their organization to be more agile, more competitive, and more profitable. Successful Business Intelligence offers valuable guidance for companies looking to embark upon their first BI project as well as those hoping to maximize their current deployments." --John Schwarz, CEO, Business Objects "A thoughtful, clearly written, and carefully researched examination of all facets of business intelligence that your organization needs to know to run its business more intelligently and exploit information to its fullest extent." --Wayne Eckerson, Director, TDWI Research "Using real-world examples, Cindi Howson shows you how to use business intelligence to improve the performance, and the quality, of your company." --Bill Baker, Distinguished Engineer & GM, Business Intelligence Applications, Microsoft Corporation "This book outlines the key steps to make BI an integral part of your company's culture and demonstrates how your company can use BI as a competitive differentiator." --Robert VanHees, CFO, Corporate Express "Given the trend to expand the business analytics user base, organizations are faced with a number of challenges that affect the success rate of these projects. This insightful book provides practical advice on improving that success rate." --Dan Vesset, Vice President, Business Analytics Solution Research, IDC




Learn Power BI


Book Description

Solve business challenges with Microsoft Power BI's advanced visualization and data analysis techniques Key FeaturesCreate effective storytelling reports by implementing simple-to-intermediate Power BI featuresDevelop powerful analytical models to extract key insights for changing business needsBuild, publish, and share impressive dashboards for your organizationBook Description To succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This Power BI book is an entry-level guide that will get you up and running with data modeling, visualization, and analytical techniques from scratch. You'll find this book handy if you want to get well-versed with the extensive Power BI ecosystem. You'll start by covering the basics of business intelligence and installing Power BI. You'll then learn the wide range of Power BI features to unlock business insights. As you progress, the book will take you through how to use Power Query to ingest, cleanse, and shape your data, and use Power BI DAX to create simple to complex calculations. You'll also be able to add a variety of interactive visualizations to your reports to bring your data to life. Finally, you'll gain hands-on experience in creating visually stunning reports that speak to business decision makers, and see how you can securely share these reports and collaborate with others. By the end of this book, you'll be ready to create simple, yet effective, BI reports and dashboards using the latest features of Power BI. What you will learnExplore the different features of Power BI to create interactive dashboardsUse the Query Editor to import and transform dataPerform simple and complex DAX calculations to enhance analysisDiscover business insights and tell a story with your data using Power BIExplore data and learn to manage datasets, dataflows, and data gatewaysUse workspaces to collaborate with others and publish your reportsWho this book is for If you’re an IT manager, data analyst, or BI user new to using Power BI for solving business intelligence problems, this book is for you. You’ll also find this book useful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.




Data Governance


Book Description

Managing data continues to grow as a necessity for modern organizations. There are seemingly infinite opportunities for organic growth, reduction of costs, and creation of new products and services. It has become apparent that none of these opportunities can happen smoothly without data governance. The cost of exponential data growth and privacy / security concerns are becoming burdensome. Organizations will encounter unexpected consequences in new sources of risk. The solution to these challenges is also data governance; ensuring balance between risk and opportunity. Data Governance, Second Edition, is for any executive, manager or data professional who needs to understand or implement a data governance program. It is required to ensure consistent, accurate and reliable data across their organization. This book offers an overview of why data governance is needed, how to design, initiate, and execute a program and how to keep the program sustainable. This valuable resource provides comprehensive guidance to beginning professionals, managers or analysts looking to improve their processes, and advanced students in Data Management and related courses. With the provided framework and case studies all professionals in the data governance field will gain key insights into launching successful and money-saving data governance program. - Incorporates industry changes, lessons learned and new approaches - Explores various ways in which data analysts and managers can ensure consistent, accurate and reliable data across their organizations - Includes new case studies which detail real-world situations - Explores all of the capabilities an organization must adopt to become data driven - Provides guidance on various approaches to data governance, to determine whether an organization should be low profile, central controlled, agile, or traditional - Provides guidance on using technology and separating vendor hype from sincere delivery of necessary capabilities - Offers readers insights into how their organizations can improve the value of their data, through data quality, data strategy and data literacy - Provides up to 75% brand-new content compared to the first edition




Business Intelligence For Dummies


Book Description

You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in making the right decisions about your business. But you’ve heard at least a dozen definitions of what it is, and heard of at least that many BI tools. Where do you start? Business Intelligence For Dummies makes BI understandable! It takes you step by step through the technologies and the alphabet soup, so you can choose the right technology and implement a successful BI environment. You'll see how the applications and technologies work together to access, analyze, and present data that you can use to make better decisions about your products, customers, competitors, and more. You’ll find out how to: Understand the principles and practical elements of BI Determine what your business needs Compare different approaches to BI Build a solid BI architecture and roadmap Design, develop, and deploy your BI plan Relate BI to data warehousing, ERP, CRM, and e-commerce Analyze emerging trends and developing BI tools to see what else may be useful Whether you’re the business owner or the person charged with developing and implementing a BI strategy, checking out Business Intelligence For Dummies is a good business decision.




Data Analytics: Principles, Tools, and Practices


Book Description

A Complete Data Analytics Guide for Learners and Professionals. KEY FEATURES ● Learn Big Data, Hadoop Architecture, HBase, Hive and NoSQL Database. ● Dive into Machine Learning, its tools, and applications. ● Coverage of applications of Big Data, Data Analysis, and Business Intelligence. DESCRIPTION These days critical problem solving related to data and data sciences is in demand. Professionals who can solve real data science problems using data science tools are in demand. The book “Data Analytics: Principles, Tools, and Practices” can be considered a handbook or a guide for professionals who want to start their journey in the field of data science. The journey starts with the introduction of DBMS, RDBMS, NoSQL, and DocumentDB. The book introduces the essentials of data science and the modern ecosystem, including the important steps such as data ingestion, data munging, and visualization. The book covers the different types of analysis, different Hadoop ecosystem tools like Apache Spark, Apache Hive, R, MapReduce, and NoSQL Database. It also includes the different machine learning techniques that are useful for data analytics and how to visualize data with different graphs and charts. The book discusses useful tools and approaches for data analytics, supported by concrete code examples. After reading this book, you will be motivated to explore real data analytics and make use of the acquired knowledge on databases, BI/DW, data visualization, Big Data tools, and statistical science. WHAT YOU WILL LEARN ● Familiarize yourself with Apache Spark, Apache Hive, R, MapReduce, and NoSQL Database. ● Learn to manage data warehousing with real time transaction processing. ● Explore various machine learning techniques that apply to data analytics. ● Learn how to visualize data using a variety of graphs and charts using real-world examples from the industry. ● Acquaint yourself with Big Data tools and statistical techniques for machine learning. WHO THIS BOOK IS FOR IT graduates, data engineers and entry-level professionals who have a basic understanding of the tools and techniques but want to learn more about how they fit into a broader context are encouraged to read this book. TABLE OF CONTENTS 1. Database Management System 2. Online Transaction Processing and Data Warehouse 3. Business Intelligence and its deeper dynamics 4. Introduction to Data Visualization 5. Advanced Data Visualization 6. Introduction to Big Data and Hadoop 7. Application of Big Data Real Use Cases 8. Application of Big Data 9. Introduction to Machine Learning 10. Advanced Concepts to Machine Learning 11. Application of Machine Learning




The Adventurous and Practical Journey to a Large-Scale Enterprise Solution


Book Description

The high failure rate of enterprise resource planning (ERP) projects is a pressing concern for both academic researchers and industrial practitioners. The challenges of an ERP implementation are particularly high when the project involves designing and developing a system from scratch. Organizations often turn to vendors and consultants for handling such projects but, every aspect of an ERP project is opaque for both customers and vendors. Unlocking the mysteries of building a large-scale ERP system, The Adventurous and Practical Journey to a Large-Scale Enterprise Solution tells the story of implementing an applied enterprise solution. The book covers the field of enterprise resource planning by examining state-of-the-art concepts in software project management methodology, design and development integration policy, and deployment framework, including: A hybrid project management methodology using waterfall as well as a customized Scrum-based approach A novel multi-tiered software architecture featuring an enhanced flowable process engine A unique platform for coding business processes efficiently Integration to embed ERP modules in physical devices A heuristic-based framework to successfully step into the Go-live period Written to help ERP project professionals, the book charts the path that they should travel from project ideation to systems implementation. It presents a detailed, real-life case study of implementing a large-scale ERP and uses storytelling to demonstrate incorrect and correct decisions frequently made by vendors and customers. Filled with practical lessons learned, the book explains the ins and outs of adopting project methodologies. It weaves a tale that features both real-world and scholarly aspects of an ERP implementation.




Guide to Business Data Analytics


Book Description

The Guide to Business Data Analytics provides a foundational understanding of business data analytics concepts and includes how to develop a framework; key techniques and application; how to identify, communicate and integrate results; and more. This guide acts as a reference for the practice of business data analytics and is a companion resource for the Certification in Business Data Analytics (IIBA(R)- CBDA). Explore more information about the Certification in Business Data Analytics at IIBA.org/CBDA. About International Institute of Business Analysis International Institute of Business Analysis(TM) (IIBA(R)) is a professional association dedicated to supporting business analysis professionals deliver better business outcomes. IIBA connects almost 30,000 Members, over 100 Chapters, and more than 500 training, academic, and corporate partners around the world. As the global voice of the business analysis community, IIBA supports recognition of the profession, networking and community engagement, standards and resource development, and comprehensive certification programs. IIBA Publications IIBA publications offer a wide variety of knowledge and insights into the profession and practice of business analysis for the entire business community. Standards such as A Guide to the Business Analysis Body of Knowledge(R) (BABOK(R) Guide), the Agile Extension to the BABOK(R) Guide, and the Global Business Analysis Core Standard represent the most commonly accepted practices of business analysis around the globe. IIBA's reports, research, whitepapers, and studies provide guidance and best practices information to address the practice of business analysis beyond the global standards and explore new and evolving areas of practice to deliver better business outcomes. Learn more at iiba.org.




Business Intelligence Guidebook


Book Description

Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors' tools lies the essential, yet poorly-understood layer of architecture, design and process. Without this knowledge, Big Data is belittled – projects flounder, are late and go over budget. Business Intelligence Guidebook: From Data Integration to Analytics shines a bright light on an often neglected topic, arming you with the knowledge you need to design rock-solid business intelligence and data integration processes. Practicing consultant and adjunct BI professor Rick Sherman takes the guesswork out of creating systems that are cost-effective, reusable and essential for transforming raw data into valuable information for business decision-makers. After reading this book, you will be able to design the overall architecture for functioning business intelligence systems with the supporting data warehousing and data-integration applications. You will have the information you need to get a project launched, developed, managed and delivered on time and on budget – turning the deluge of data into actionable information that fuels business knowledge. Finally, you'll give your career a boost by demonstrating an essential knowledge that puts corporate BI projects on a fast-track to success. - Provides practical guidelines for building successful BI, DW and data integration solutions. - Explains underlying BI, DW and data integration design, architecture and processes in clear, accessible language. - Includes the complete project development lifecycle that can be applied at large enterprises as well as at small to medium-sized businesses - Describes best practices and pragmatic approaches so readers can put them into action. - Companion website includes templates and examples, further discussion of key topics, instructor materials, and references to trusted industry sources.




HBR Guide to Data Analytics Basics for Managers (HBR Guide Series)


Book Description

Don't let a fear of numbers hold you back. Today's business environment brings with it an onslaught of data. Now more than ever, managers must know how to tease insight from data--to understand where the numbers come from, make sense of them, and use them to inform tough decisions. How do you get started? Whether you're working with data experts or running your own tests, you'll find answers in the HBR Guide to Data Analytics Basics for Managers. This book describes three key steps in the data analysis process, so you can get the information you need, study the data, and communicate your findings to others. You'll learn how to: Identify the metrics you need to measure Run experiments and A/B tests Ask the right questions of your data experts Understand statistical terms and concepts Create effective charts and visualizations Avoid common mistakes