In 2020, the world celebrated the brand new 12 months with many uncertainties. Effectively, life is filled with uncertainties, however, this one was very completely different. The world was dealing with a brand new pandemic that by no means skilled earlier than. The primary COVID19 case in New Zealand was confirmed in February 2020. In March 2020 your complete nation went to lockdown for the primary time. The world was experiencing an enormous risk altering everybody’s lives. I used to be no completely different. Day-after-day was beginning with unhealthy information. A relative handed away; a buddy acquired the virus; the shoppers put the tasks on maintain and so on. Nothing was wanting regular anymore. You possibly can’t even go to get a correct haircut, as a result of everyone seems to be in lockdown. That is me making an attempt to smile after getting a selfmade haircut. I wager a lot of you have got completed the identical factor.
Someday, I checked my electronic mail and noticed a message from Packt Publishing. They needed to see if I’m keen on writing a e-book about Energy BI. That was a bit of fine information after a very long time. I at all times needed to put in writing a e-book about Energy BI. Certainly, I tried for the primary time in 2016, however I couldn’t handle to get my geese in a row to understand the publishers’ consideration.
I used to be not unfamiliar with writing books; certainly, I wrote my first e-book again in 2006 about Multimedia Functions in Persian. One among my passions in life is listening to music. And CDs have been probably the most accessible music supply with high-quality sound. I recall I saved cash for some months, and I purchased a Discman to take heed to the music on the go. However CDs are reasonably cumbersome, and you would not have a lot of them in your pocket. So the subsequent challenge was to save lots of much more cash to purchase an MP3 participant. However, changing Audio CDs to MP3 with out compromising rather a lot on the sound high quality was an actual problem for many individuals. And, that was my motive to put in writing my first e-book in Persian to share my little data with everybody.
Whereas I used to be acquainted with writing books, my earlier expertise was fairly completely different as my e-book was in Persian, my first language. So writing a technical e-book in English might be an actual problem. So, the e-mail from Packt Publishing might be a game-changer in some ways. Now, I had an enormous challenge to take care of; as a substitute of serious about all of the adverse pandemic information. I made a decision to just accept the problem and embraced the chance. In Could 2020, I formally began writing my e-book, Professional Knowledge Modeling with Energy BI. I had lengthy days with a brilliant busy schedule for greater than a 12 months. I labored very arduous to handle my duties because the founding father of Knowledge Vizioner and sustain with the product improvement, dealing with my consultancy position, writing my e-book and on the similar time making an appropriate work-life stability. I labored between 12 to 16 hours a day, together with the weekends. However all of the arduous works paid off after my e-book was printed in June 2021.
What’s in This Ebook for You?
Microsoft Energy BI is likely one of the hottest enterprise intelligence instruments accessible in the marketplace that you need to use in your native machine and the cloud. This e-book will likely be your information to understanding completely different points of knowledge modelling, so the main focus of this e-book is to not train you the right way to write DAX expressions. For that matter, there are significantly better books on the market that I personally seek advice from on some events. The most effective ones for studying DAX, for my part, are:
- Phill Seamark’s books:
- Starting DAX with Energy BI: The SQL Professional’s Information to Higher Enterprise Intelligence
- Professional DAX with Energy BI: Enterprise Intelligence with PowerPivot and SQL Server Evaluation Providers Tabular
- Marco Russo and Alberto Ferrari’s e-book:
- Definitive Information to DAX, The : Enterprise intelligence for Microsoft Energy BI, SQL Server Evaluation Providers, and Excel by Marco Russo and Alberto Ferrari
Whereas my e-book closely makes use of many Energy Question strategies, however once more, the principle focus is just not on Energy Question. For studying Energy Question, I recommend studying the next e-book:
To make it clearer, my e-book discusses numerous DAX and Energy Question, however, the main focus of the e-book is to not remedy all modelling challenges solely with Energy Question or DAX. The main target right here is certainly on Energy Question, DAX and plenty of different points of knowledge modelling. For example, the e-book covers the circulation of knowledge in several layers of Energy BI Desktop; an idea which may look trivial to many readers, however the truth is, it’s a essential idea that if we don’t perceive it properly, we can not create a very good information mannequin. So, the e-book begins discussing some constructing blocks, then it covers many points of superior information modelling. So, no matter your degree of data, the Professional Knowledge Modelling with Energy BI has one thing for you.
What this e-book covers
The next sections clarify what the e-book covers in several chapters.
Chapter 1, Introduction to Knowledge Modeling in Energy BI
This chapter briefly describes the completely different functionalities of Energy BI and why information modelling is essential. This chapter additionally reveals some essential notes to be thought-about round Energy BI licensing, which probably might have an effect on your information mannequin. This chapter introduces an iterative information modelling method, which ensures an agile Energy BI implementation.
Chapter 2, Knowledge Evaluation eXpressions and Knowledge Modeling
This chapter doesn’t focus on numerous DAX as in components 3 and 4 of this e-book DAX is closely used to resolve completely different information modelling challenges. Due to this fact, we’ll solely give attention to the DAX functionalities which can be tougher to grasp and are very related to information modelling. This chapter begins with a fast introduction to DAX, then we soar straight to digital tables and time intelligence functionalities and their purposes in real-world eventualities.
Chapter 3, Knowledge Preparation in Energy Question Editor
This chapter shortly explains the parts of Energy Question and their utility. It expresses the emphasis of making question parameters and user-defined features together with real-world use instances and eventualities to display how highly effective they’re in constructing far more versatile and maintainable fashions.
Chapter 4, Getting Knowledge from Varied Sources
This chapter explains getting information from completely different information sources which can be extra generally utilized in Energy BI. Then, the significance of knowledge supply certification is defined, which helps you set your expectations on the kind of information you’re going to take care of. That is particularly useful in estimating information modelling efforts. Completely different connection modes are additionally defined on this chapter.
Chapter 5, Widespread Knowledge Preparation Steps
Explains widespread information preparation steps together with real-world hands-on eventualities. A mixture of what you have got realized up to now on this e-book with the steps to be mentioned on this chapter offers you a robust basis to go on to the subsequent chapters and construct your information fashions extra effectively. By studying these functionalities, you’ll be able to take care of numerous completely different eventualities in implementing completely different information fashions.
Chapter 6, Star Schema Preparation in Energy Question Editor
Explains the right way to put together your queries primarily based on the star schema information modelling method with real-life eventualities. The Energy Question M language will likely be closely used on this chapter, so you’ll learn to take care of real-world challenges alongside the best way. As you have got already realized widespread information preparation steps within the earlier chapter, nearly all of Energy Question eventualities defined on this chapter will likely be simpler to implement. You’ll additionally learn to construct dimension tables and truth tables, and the right way to denormalize your queries when wanted.
Chapter 7, Knowledge Preparation Widespread Greatest Practices
Explains widespread finest practices in information preparation. Following these practices will aid you construct extra environment friendly information fashions which can be simpler to keep up and extra versatile to make modifications to. Following these practices, you too can keep away from widespread errors, which may make your life a lot simpler.
Chapter 8, Knowledge Modeling Elements
Explains information modelling parts from a Energy BI perspective together with actual file examples. On this chapter, we closely use DAX when relevant so having a primary understanding of DAX is important. We even have a whole star schema mannequin in Energy BI. The idea of config tables is roofed, which unlocks numerous potentialities in dealing with extra advanced enterprise logic within the information mannequin. The chapter
ends with information modelling naming conventions.
Chapter 9, Star Shema and Knowledge Modeling Widespread Greatest Practices
This chapter explains widespread information modelling finest practices that can assist you make higher selections whereas constructing your information mannequin to stop dealing with some identified points down the street. For example, coping with information sort points in key columns which can be utilized in relationships is considerably time-consuming to determine, but it surely’s very simple to stop. So, understanding information modelling finest practices helps you save numerous upkeep time and consequently saves you cash.
Chapter 10, Superior Knowledge Modeling Methods
This chapter explains particular modelling strategies that remedy particular enterprise necessities. An excellent information modeller is one who’s at all times open to new challenges. You might face a few of the superior enterprise necessities mentioned on this chapter or you might face one thing completely different however related. The message we wish to ship on this chapter is to assume freely when coping with new enterprise challenges and attempt to be
modern to get the perfect outcomes.
Chapter 11, Row-Stage Safety
Explains the right way to implement row-level safety (RLS) in a Energy BI information mannequin. Coping with RLS might be advanced and understanding the right way to take care of completely different conditions wants deep data on information modelling and filter propagation ideas. Our purpose on this chapter is to switch that data to you so you’ll be able to design and implement high-performing and low-maintenance information fashions.
Chapter 12, Additional Choices and Options Out there for Knowledge Modeling
This chapter introduces information modelling choices similar to Slowly Altering Dimensions (SCD), Object-Stage Safety (OLS), dataflows, and composite fashions, providing you with broad publicity to all these subjects.
I Was Not Alone Alongside the Manner
All this was not potential with out having the total help of my beautiful spouse, my mates and my household. I additionally want to present my particular gratefulness to 2 wonderful professionals:
I additionally thank the next Microsoft MVPs who put their useful time to evaluation my e-book after publication and supplied their suggestions:
Thanks everybody in your help.