The Definitive Guide to DAX

The Definitive Guide to DAX
Author: Alberto Ferrari
Publisher: Microsoft Press
Total Pages: 1515
Release: 2015-10-14
Genre: Computers
ISBN: 0735698376

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

Business Intelligence

Business Intelligence
Author: Carlo Vercellis
Publisher: John Wiley & Sons
Total Pages: 314
Release: 2011-08-10
Genre: Mathematics
ISBN: 1119965470

Business intelligence is a broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better business decisions. The term implies having a comprehensive knowledge of all factors that affect a business, such as customers, competitors, business partners, economic environment, and internal operations, therefore enabling optimal decisions to be made. Business Intelligence provides readers with an introduction and practical guide to the mathematical models and analysis methodologies vital to business intelligence. This book: Combines detailed coverage with a practical guide to the mathematical models and analysis methodologies of business intelligence. Covers all the hot topics such as data warehousing, data mining and its applications, machine learning, classification, supply optimization models, decision support systems, and analytical methods for performance evaluation. Is made accessible to readers through the careful definition and introduction of each concept, followed by the extensive use of examples and numerous real-life case studies. Explains how to utilise mathematical models and analysis models to make effective and good quality business decisions. This book is aimed at postgraduate students following data analysis and data mining courses. Researchers looking for a systematic and broad coverage of topics in operations research and mathematical models for decision-making will find this an invaluable guide.

Data Analysis with Microsoft Power BI

Data Analysis with Microsoft Power BI
Author: Brian Larson
Publisher: McGraw Hill Professional
Total Pages: 546
Release: 2020-01-03
Genre: Computers
ISBN: 1260458628

Explore, create, and manage highly interactive data visualizations using Microsoft Power BI Extract meaningful business insights from your disparate enterprise data using the detailed information contained in this practical guide. Written by a recognized BI expert and bestselling author, Data Analysis with Microsoft Power BI teaches you the skills you need to interact with, author, and maintain robust visualizations and custom data models. Hands-on exercises based on real-life business scenarios clearly demonstrate each technique. Publishing your results to the Power BI Service (PowerBI.com) and Power BI Report Server are also fully covered. Inside, you will discover how to: •Understand Business Intelligence and self-service analytics •Explore the tools and features of Microsoft Power BI •Create and format effective data visualizations •Incorporate advanced interactivity and custom graphics •Build and populate accurate data models •Transform data using the Power BI Query Editor •Work with measures, calculated columns, and tabular models •Write powerful DAX language scripts •Share content on the PowerBI Service (PowerBI.com) •Store your visualizations on the Power BI Report Server

Business Intelligence Guidebook

Business Intelligence Guidebook
Author: Rick Sherman
Publisher: Newnes
Total Pages: 551
Release: 2014-11-04
Genre: Computers
ISBN: 0124115284

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.

Mastering Microsoft Power BI

Mastering Microsoft Power BI
Author: Brett Powell
Publisher: Packt Publishing Ltd
Total Pages: 632
Release: 2018-03-29
Genre: Computers
ISBN: 1788292286

Design, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master all the dashboarding and reporting features of Microsoft Power BI Combine data from multiple sources, create stunning visualizations and publish your reports across multiple platforms A comprehensive guide with real-world use cases and examples demonstrating how you can get the best out of Microsoft Power BI Book DescriptionThis book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization. BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. BI managers will learn how Power BI’s tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed. By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft Power BI.What you will learn Build efficient data retrieval and transformation processes with the Power Query M Language Design scalable, user-friendly DirectQuery and Import Data Models Develop visually rich, immersive, and interactive reports and dashboards Maintain version control and stage deployments across development, test, and production environments Manage and monitor the Power BI Service and the On-premises data gateway Develop a fully on-premise solution with the Power BI Report Server Scale up a Power BI solution via Power BI Premium capacity and migration to Azure Analysis Services or SQL Server Analysis Services Who this book is for Business Intelligence professionals and existing Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book to be useful. While understanding of the basic BI concepts is required, some exposure to Microsoft Power BI will be helpful.

Mastering Tableau 2019.1

Mastering Tableau 2019.1
Author: Marleen Meier
Publisher: Packt Publishing Ltd
Total Pages: 544
Release: 2019-02-28
Genre: Computers
ISBN: 1789530709

Build, design and improve advanced business intelligence solutions using Tableau’s latest features, including Tableau Prep, Tableau Hyper, and Tableau Server Key FeaturesMaster new features in Tableau 2019.1 to solve real-world analytics challengesPerform Geo-Spatial Analytics, Time Series Analysis, and self-service analytics using real-life examplesBuild and publish dashboards and explore storytelling using Python and MATLAB integration supportBook Description Tableau is one of the leading business intelligence (BI) tools used to solve BI and analytics challenges. With this book, you will master Tableau's features and offerings in various paradigms of the BI domain. This book is also the second edition of the popular Mastering Tableau series, with new features, examples, and updated code. The book covers essential Tableau concepts and its advanced functionalities. Using Tableau Hyper and Tableau Prep, you’ll be able to handle and prepare data easily. You’ll gear up to perform complex joins, spatial joins, union, and data blending tasks using practical examples. Following this, you’ll learn how to perform data densification to make displaying granular data easier. Next, you’ll explore expert-level examples to help you with advanced calculations, mapping, and visual design using various Tableau extensions. With the help of examples, you’ll also learn about improving dashboard performance, connecting Tableau Server, and understanding data visualizations. In the final chapters, you’ll cover advanced use cases such as Self-Service Analytics, Time Series Analytics, and Geo-Spatial Analytics, and learn to connect Tableau to R, Python, and MATLAB. By the end of this book, you’ll have mastered the advanced offerings of Tableau and be able to tackle common and not-so-common challenges faced in the BI domain. What you will learnGet up to speed with various Tableau componentsMaster data preparation techniques using Tableau PrepDiscover how to use Tableau to create a PowerPoint-like presentationUnderstand different Tableau visualization techniques and dashboard designsInteract with the Tableau server to understand its architecture and functionalitiesStudy advanced visualizations and dashboard creation techniquesBrush up on powerful Self-Service Analytics, Time Series Analytics, and Geo-Spatial AnalyticsWho this book is for This book is designed for business analysts, BI professionals and data analysts who want to master Tableau to solve a range of data science and business intelligence problems. The book is ideal if you have a good understanding of Tableau and want to take your skills to the next level.

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Author: Gil Raviv
Publisher: Microsoft Press
Total Pages: 874
Release: 2018-10-08
Genre: Computers
ISBN: 1509307974

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you’re finished, you’ll be ready to wrangle any data–and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query · Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI · Solve common data preparation problems with a few mouse clicks and simple formula edits · Combine data from multiple sources, multiple queries, and mismatched tables · Master basic and advanced techniques for unpivoting tables · Customize transformations and build flexible data mashups with the M formula language · Address collaboration challenges with Power Query · Gain crucial insights into text feeds · Streamline complex social network analytics so you can do it yourself For all information workers, analysts, and any Excel user who wants to solve their own business intelligence problems.

Business Intelligence and Analytics

Business Intelligence and Analytics
Author: Ramesh Sharda
Publisher: Pearson
Total Pages: 688
Release: 2014-02-28
Genre: Business intelligence
ISBN: 9781292009209

Decision Support and Business Intelligence Systems provides the only comprehensive, up-to-date guide to today's revolutionary management support system technologies, and showcases how they can be used for better decision-making. The 10th edition focuses on Business Intelligence (BI) and analytics for enterprise decision support in a more streamlined book.

Successful Business Intelligence: Secrets to Making BI a Killer App

Successful Business Intelligence: Secrets to Making BI a Killer App
Author: Cindi Howson
Publisher: McGraw Hill Professional
Total Pages: 258
Release: 2007-12-17
Genre: Computers
ISBN: 0071596143

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

Business Intelligence

Business Intelligence
Author: Ramesh Sharda
Publisher: Pearson
Total Pages: 512
Release: 2017-01-13
Genre: Business & Economics
ISBN: 9780134633282

For courses on Business Intelligence or Decision Support Systems. A managerial approach to understanding business intelligence systems. To help future managers use and understand analytics, Business Intelligence provides students with a solid foundation of BI that is reinforced with hands-on practice.