Download or read book Power BI 2019 Volume 2 written by Roger F Silva and published by . This book was released on 2019-10-04 with total page 308 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Excellent hands-on introduction to Power Bi" "Great way to learn Power BI" Power BI 2019 - Volume 2 is a Power BI Series, presented in two parts! Part 1: Power BI - Business Intelligence Clinic If you want to learn Business Intelligence software, if you are looking for a specific BI tool, or if you are trying to decide on your next new BI solution, you will love the Business Intelligence Clinic. One dataset, multiple solutions Each book is about a different BI software, and you will follow step-by-step instructions to create a professional sales dashboard with the same friendly dataset. The BI Clinic series is suitable for everyone - managers, analysts, students... - It will help you compare different Business Intelligence tools, learn the basics, and select the best for your project, company, customers, or personal needs. In this Create and Learn book, Power BI - Business Intelligence Clinic with more than 300 Black and White images, you will you go through important topics of Microsoft Power BI Desktop - a Free BI tool from Microsoft. You will learn how to install Power BI Desktop, get data, model your data, work with visuals and reports, create a sales dashboard, and share your work with others. You will follow step-by-step instructions to create a professional sales dashboard, and eight warm-up dashboards to help you rapidly increase your Power BI knowledge. Part 2: Power BI Academy vol. 2 - Healthcare Power BI Academy is a series of short books that help students and professionals improve their Power Business Intelligence (BI) knowledge by creating professional dashboards through easy step-by-step instructions. Through this series, you will have the opportunity to work with datasets, metrics, and Key Performance Indicators (KPIs) from a wide range of industries, helping you become a valuable resource to any team and industry. In this book, Power BI Academy vol.2 - Healthcare, which has over 200 Black and White images, you will learn to create a unique Dashboard for the Healthcare Industry. You go through important topics of Microsoft Power BI Desktop, a Free BI tool from Microsoft. You will learn how to install Power BI Desktop, get data from Excel, model your Data, work with visuals and reports, create a Patient Overview Dashboard, and share your work. We will not go into deep theories as to the purpose of this book, and all Create and Learn material is to make the most of your time and learn by doing. You will follow step-by-step instructions to create a professional Healthcare Dashboard to help you rapidly increase your knowledge. Book details: Skill Level: Beginner Estimated time to complete: 2 hours I also hope this book series will help start your journey in the Business Intelligence world and provide the necessary tools to create professional reports and dashboards using Microsoft Power BI. Be sure to check my other books: Power BI - Business Intelligence Clinic Excel - Business Intelligence Clinic Tableau - Business Intelligence Clinic

Download or read book Introducing Microsoft Power BI written by Alberto Ferrari and published by Microsoft Press. This book was released on 2016-07-07 with total page 453 pages. Available in PDF, EPUB and Kindle. Book excerpt: This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:http://aka.ms/analyzingdata/details. Learn more about Power BI at https://powerbi.microsoft.com/.

Download or read book Mastering Microsoft Power BI written by Brett Powell and published by Packt Publishing Ltd. This book was released on 2018-03-29 with total page 632 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Download or read book Power BI Academy Healthcare written by Create And Learn and published by . This book was released on 2019-09-26 with total page 142 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Excellent hands-on introduction to Power Bi" "Great way to learn Power BI" Power BI Academy is a series of short books that help students and professionals improve their Power Business Intelligence (BI) knowledge by creating professional dashboards through easy step-by-step instructions. Through this series, you will have the opportunity to work with datasets, metrics, and Key Performance Indicators (KPIs) from a wide range of industries, helping you become a valuable resource to any team and industry. In this book, Power BI Academy vol.2 - Healthcare, which has over 200 images, you will learn to create a unique Dashboard for the Healthcare Industry. You go through important topics of Microsoft Power BI Desktop, a Free BI tool from Microsoft. You will learn how to install Power BI Desktop, get data from Excel, model your Data, work with visuals and reports, create a Patient Overview Dashboard, and share your work. We will not go into deep theories as to the purpose of this book, and all Create and Learn material is to make the most of your time and learn by doing. You will follow step-by-step instructions to create a professional Healthcare Dashboard to help you rapidly increase your knowledge. I also hope this book will help start your journey in the Business Intelligence world and provide the necessary tools to create professional reports and dashboards using Microsoft Power BI. Check my other books: Power BI - Business Intelligence Clinic Excel - Business Intelligence Clinic Tableau - Business Intelligence Clinic

Download or read book The Definitive Guide to DAX written by Alberto Ferrari and published by Microsoft Press. This book was released on 2015-10-14 with total page 1515 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Download or read book Collect Combine and Transform Data Using Power Query in Excel and Power BI written by Gil Raviv and published by Microsoft Press. This book was released on 2018-10-08 with total page 874 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Download or read book Introduction to Microsoft Power BI written by M. Cuddley and published by Createspace Independent Publishing Platform. This book was released on 2016-05-20 with total page 128 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is meant to serve as an introductory guide which will take you from the point of having zero or very little knowledge about Power BI, to the point where you can comfortably produce reports and dashboards that provide useful organizational insights.

Download or read book Expert Data Modeling with Power BI written by Soheil Bakhshi and published by Packt Publishing Ltd. This book was released on 2021-06-11 with total page 612 pages. Available in PDF, EPUB and Kindle. Book excerpt: Manage and work with business data effectively by learning data modeling techniques and leveraging the latest features of Power BI Key Features Understand data modeling techniques to get the best out of data using Power BI Define the relationships between data to extract valuable insights Solve a wide variety of business challenges by building optimal data models Book DescriptionThis book is a comprehensive guide to understanding the ins and outs of data modeling and how to create data models using Power BI confidently. You'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization. In this book, you'll explore how to use data modeling and navigation techniques to define relationships and create a data model before defining new metrics and performing custom calculations using modeling features. As you advance through the chapters, the book will demonstrate how to create full-fledged data models, enabling you to create efficient data models and simpler DAX code with new data modeling features. With the help of examples, you'll discover how you can solve business challenges by building optimal data models and changing your existing data models to meet evolving business requirements. Finally, you'll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks. By the end of this Power BI book, you'll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support reporting and data analytics.What you will learn Implement virtual tables and time intelligence functionalities in DAX to build a powerful model Identify Dimension and Fact tables and implement them in Power Query Editor Deal with advanced data preparation scenarios while building Star Schema Explore best practices for data preparation and modeling Discover different hierarchies and their common pitfalls Understand complex data models and how to decrease the level of model complexity with different approaches Learn advanced data modeling techniques such as aggregations, incremental refresh, and RLS/OLS Who this book is for This MS Power BI book is for BI users, data analysts, and analysis developers who want to become well-versed with data modeling techniques to make the most of Power BI. You’ll need a solid grasp on basic use cases and functionalities of Power BI and Star Schema functionality before you can dive in.

Download or read book Power BI 2021 Volume 2 written by Roger F Silva and published by . This book was released on 2021-02-12 with total page 362 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Excellent hands-on introduction to Power Bi" "Great way to learn Power BI" Power BI 2021 - Volume 2 is a Power BI Series, presented in two parts! Part 1: Power BI - Business Intelligence Clinic If you want to learn Business Intelligence software, if you are looking for a specific BI tool, or if you are trying to decide on your next new BI solution, you will love the Business Intelligence Clinic. One dataset, multiple solutions Each book is about a different BI software, and you will follow step-by-step instructions to create a professional sales dashboard with the same friendly dataset. The BI Clinic series is suitable for everyone - managers, analysts, students... - It will help you compare different Business Intelligence tools, learn the basics, and select the best for your project, company, customers, or personal needs. In this Create and Learn book, Power BI - Business Intelligence Clinic with more than 300 Black and White images, you will you go through important topics of Microsoft Power BI Desktop - a Free BI tool from Microsoft. You will learn how to install Power BI Desktop, get data, model your data, work with visuals and reports, create a sales dashboard, and share your work with others. You will follow step-by-step instructions to create a professional sales dashboard, and eight warm-up dashboards to help you rapidly increase your Power BI knowledge. Part 2: Power BI Academy vol. 2 - Healthcare Power BI Academy is a series of short books that help students and professionals improve their Power Business Intelligence (BI) knowledge by creating professional dashboards through easy step-by-step instructions. Through this series, you will have the opportunity to work with datasets, metrics, and Key Performance Indicators (KPIs) from a wide range of industries, helping you become a valuable resource to any team and industry. In this book, Power BI Academy vol.2 - Healthcare, which has over 200 Black and White images, you will learn to create a unique Dashboard for the Healthcare Industry. You go through important topics of Microsoft Power BI Desktop, a Free BI tool from Microsoft. You will learn how to install Power BI Desktop, get data from Excel, model your Data, work with visuals and reports, create a Patient Overview Dashboard, and share your work. We will not go into deep theories as to the purpose of this book, and all Create and Learn material is to make the most of your time and learn by doing. You will follow step-by-step instructions to create a professional Healthcare Dashboard to help you rapidly increase your knowledge. Book details: Skill Level: Beginner Estimated time to complete: 2 hours I also hope this book series will help start your journey in the Business Intelligence world and provide the necessary tools to create professional reports and dashboards using Microsoft Power BI. Be sure to check my other books: Power BI - Business Intelligence Clinic Excel - Business Intelligence Clinic Tableau - Business Intelligence Clinic

Download or read book Power BI written by Rob Botwright and published by Rob Botwright. This book was released on 101-01-01 with total page 294 pages. Available in PDF, EPUB and Kindle. Book excerpt: Unlock the Full Potential of Your Data with the "Power BI Data Mastery Made Easy" Book Bundle! Are you ready to transform your data into actionable insights and make informed decisions that drive success? Look no further! Introducing the "Power BI Data Mastery Made Easy" book bundle, a comprehensive collection of resources that will empower you to harness the true power of Microsoft's leading business intelligence and data visualization tool—Power BI. Here's what you'll discover in this incredible bundle: Book 1 - Power BI Essentials: A Beginner's Guide to Data Visualization Mastery · Ideal for beginners: Build a solid foundation in data visualization. · Learn to import and transform data from various sources. · Create stunning visualizations that tell compelling data stories. · Master the art of data analysis and visualization. Book 2 - Mastering Power BI: Advanced Techniques and Best Practices for Analysts · Elevate your skills to the next level with advanced techniques. · Discover best practices for tackling complex analytical challenges. · Master DAX formulas and optimize data models. · Become an analytics expert and excel in your field. Book 3 - Power BI Data Modeling: Building Robust Datasets for Effective Analysis · Unlock the full potential of Power BI with robust data modeling. · Design efficient and flexible data models. · Establish relationships between tables and optimize performance. · Gain the skills to create powerful data sets for effective analysis. Book 4 - Expert Power BI: Advanced Analytics and Custom Visualizations Mastery · Dive into the world of advanced analytics and custom visuals. · Explore machine learning integration and geographic analysis. · Push the boundaries of data analysis and create custom solutions. · Become a Power BI expert and stand out in your field. Whether you're a business professional, data analyst, or IT specialist, this book bundle equips you with the knowledge and skills needed to transform your data into a valuable asset. With Power BI's dynamic and ever-evolving capabilities, these books will keep you on the cutting edge of data analytics. Don't miss out on this opportunity to embark on a journey of discovery, learning, and mastery in the world of Power BI. Your ability to turn data into actionable insights is the key to informed decision-making and driving success in today's data-centric environment. Grab the "Power BI Data Mastery Made Easy" book bundle today and start your exciting adventure into the world of Power BI—where data mastery is within reach for everyone!

Download or read book Microsoft Power BI Dashboards Step by Step written by Errin O'Connor and published by Microsoft Press. This book was released on 2018-10-05 with total page 411 pages. Available in PDF, EPUB and Kindle. Book excerpt: Your hands-on guide to building effective Power BI dashboards Expand your expertise–and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you’re an experienced business intelligence professional or manager, you’ll get all the guidance, examples, and code you need to succeed–even if you’ve never used Power BI before. Successfully design, architect, and implement Power BI in your organization Take full advantage of any Microsoft Power BI platform, including Power BI Premium Make upfront decisions that position your Power BI project for success Build rich, live dashboards to monitor crucial data from across your organization Aggregate data and data elements from numerous internal and external data sources Develop dynamic visualizations, including charts, maps, and graphs Bring data to life with stunning interactive reports Ensure dashboard security and compliance Drive user adoption through effective training

Download or read book Microsoft Power BI Complete Reference written by Devin Knight and published by Packt Publishing Ltd. This book was released on 2018-12-21 with total page 780 pages. Available in PDF, EPUB and Kindle. Book excerpt: Design, develop, and master efficient Power BI solutions for impactful business insights Key FeaturesGet to grips with the fundamentals of Microsoft Power BI Combine data from multiple sources, create visuals, and publish reports across platformsUnderstand Power BI concepts with real-world use casesBook Description Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: Microsoft Power BI Quick Start Guide by Devin Knight et al. Mastering Microsoft Power BI by Brett PowellWhat you will learnConnect to data sources using both import and DirectQuery optionsLeverage built-in and custom visuals to design effective reportsAdminister a Power BI cloud tenant for your organizationDeploy your Power BI Desktop files into the Power BI Report ServerBuild efficient data retrieval and transformation processesWho this book is for Microsoft Power BI Complete Reference Guide is for those who want to learn and use the Power BI features to extract maximum information and make intelligent decisions that boost their business. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, then Learning Path is for you. It consists of real-world examples on Power BI and goes deep into the technical issues, covers additional protocols, and much more.

Download or read book Phenomenal Stories Quarterly Vol 2 No 1 Spring 2019 written by Shawn M. Tomlinson and published by Lulu.com. This book was released on 2019-03-06 with total page 492 pages. Available in PDF, EPUB and Kindle. Book excerpt: We press on with the second volume of Phenomenal Stories Quarterly, a collection of the first three issues of Phenomenal Stories for 2019. As a special bonus, there's a new piece titled ?From the Desk of? GEOD? not found in any issue of Phenomenal Stories. Phenomenal Stories Quarterly is a companion magazine to Phenomenal Stories in the tradition of the science fiction/fantasy/horror pulps of the 1920s, 1930s and 1940s. It's also a somewhat cheaper means to get all the issues together. This issue contains stories by Richard H. Nilsen, Haldor R. Hallum, J.D. Hayes-Canell, Bridget Flynn-O?Leary, Henry Martin and a classic reprint by Frank Belknap Long Jr. Phenomenal Stories Quarterly is a modern-day tribute to the science fiction/horror/fantasy/speculative pulp magazines of the 1920s, 1930s and 1940s.

Download or read book Dashboarding Reporting with Power BI written by Kasper de Jonge and published by Tickling Keys, Inc.. This book was released on 2018-06-01 with total page 175 pages. Available in PDF, EPUB and Kindle. Book excerpt: Microsoft’s revolutionary Power BI is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways.This book, written by a member of Microsoft’s Power BI team, provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.

Download or read book Pro Power BI Architecture written by Reza Rad and published by Apress. This book was released on 2018-11-19 with total page 544 pages. Available in PDF, EPUB and Kindle. Book excerpt: Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization. Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization, ensuring that you do not spend your time maintaining your solution but on using it for its intended purpose and gaining business value from mining and analyzing your organization’s data. What You'll LearnArchitect and administer enterprise-level Power BI solutions Choose the right sharing method for your Power BI solution Create and manage environments for development, testing, and production Implement row level security in multiple ways to secure your data Save money by choosing the right licensing plan Select a suitable connection type—Live Connection, DirectQuery, or Scheduled Refresh—for your use case Set up a Power BI gateway to bridge between on-premises data sources and the Power BI cloud service Who This Book Is For Data analysts, developers, architects, and managers who want to leverage Power BI for their reporting solution

Download or read book Learn Power BI written by Greg Deckler and published by Packt Publishing Ltd. This book was released on 2022-02-18 with total page 458 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn how to use Power BI to deliver the insights needed to help your enterprise survive and thrive Purchase of the print or Kindle book includes a free eBook in PDF format. Key Features Learn simple through to advanced Power BI features in a clear, concise way using real-world examples Develop powerful analytical models and reports that extract key business insights Publish, share and collaborate on impressive reports, dashboards, apps, and goals Book DescriptionTo succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This updated second edition of Learn Power BI takes you on a journey of data exploration and discovery, using Microsoft Power BI to ingest, cleanse, and organize data in order to unlock key business insights that can then be shared with others. This newly revised and expanded edition of Learn Power BI covers all of the latest features and interface changes and takes you through the fundamentals of business intelligence projects, how to deploy, adopt, and govern Power BI within your organization, and how to leverage your knowledge in the marketplace and broader ecosystem that is Power BI. As you progress, you will learn how to ingest, cleanse, and transform your data into stunning visualizations, reports, and dashboards that speak to business decision-makers. By the end of this Power BI book, you will be fully prepared to be the data analysis hero of your organization – or even start a new career as a business intelligence professional.What you will learn Get up and running quickly with Power BI Understand and plan your business intelligence projects Connect to and transform data using Power Query Create data models optimized for analysis and reporting Perform simple and complex DAX calculations to enhance analysis Discover business insights and create professional reports Collaborate via Power BI dashboards, apps, goals, and scorecards Deploy and govern Power BI, including using deployment pipelines Who 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 helpful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.

Download or read book Analyzing Data with Power BI and Power Pivot for Excel written by Alberto Ferrari and published by Microsoft Press. This book was released on 2017-04-28 with total page 439 pages. Available in PDF, EPUB and Kindle. Book excerpt: Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data