~VKY~ Index du Forum

~VKY~
Serveur Classic 6, Sud-Est

 FAQFAQ   RechercherRechercher   MembresMembres   GroupesGroupes   S’enregistrerS’enregistrer 
 ProfilProfil   Se connecter pour vérifier ses messages privésSe connecter pour vérifier ses messages privés   ConnexionConnexion 

Analyzing Data With Power BI And Power Pivot For Excel Bu

 
Poster un nouveau sujet   Répondre au sujet    ~VKY~ Index du Forum -> Forum PUBLIC -> Recrutement
Sujet précédent :: Sujet suivant  
Auteur Message
walvalo


Hors ligne

Inscrit le: 11 Avr 2016
Messages: 45
Masculin
Localisation: Paris

MessagePosté le: Ven 7 Juil - 16:03 (2017)    Sujet du message: Analyzing Data With Power BI And Power Pivot For Excel Bu Répondre en citant


Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)
by Alberto Ferrari



->>->>->>DOWNLOAD BOOK Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)



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







Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) Alberto Ferrari
Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) ios read library pc thepiratebay





chriswebbolap 13,394 views 9:52 Analyzing Road Traffic Accident Data in Power BI - Duration: 1:13:26Office Videos 3,211 views 3:56 Angel Investing The Gust Guide to Making Money and Having Fun Investing in Startups - Duration: 1:41The first rule is always keep it simple, and a good data model is always the first step in the right direction! Published Monday, May 08, 2017 12:17 AM by Marco Russo (SQLBI) Filed under: PowePivot, Tabular, Power BI Comment Notification If you would like to receive an email when updates are made to this post, please register here Subscribe to this post's comments using RSS Comments Brian Mather said: Bought! Loving the clarity of the chapter on slowly changing dimensionsHardcover RRP $40.95 $31.50 23%OFF BUY NOW Code Complete DV-Professional Paperback RRP $132.00 $69.25 48%OFF BUY NOW Java A Beginner's Guide A Beginner's Guide Paperback RRP $62.95 $40.50 36%OFF BUY NOW The Lessons School Forgot How to Hack Your Way Through the Technology RevAdd to Want to watch this again later? Sign in to add this video to a playlistSign in Share More Report Need to report the video? Sign in to report inappropriate contentThis last stepthat is, becoming a great data modelerwill only come with experience and after many failuresAfter all, Power BI is a self-service tool, so employees working on understanding their data can do so easily with the plethora of connectors that the May-2017 release of Power Bi has under the label, "Get Data." The books are greatAbout the Author Alberto Ferrari is a consultant, trainer and software developer in the Business Intelligence field.

:) Nonetheless, your books are the tools in my arsenal to analyze data at a business-unit levelIn the book, we do not cover any aspect of the user interface of either Excel or Power BIAn example of an excellent book format on this topic can be a full-color large-format book Power Pivot and Power BI 2 by Rob Collie and Avichal Singh Databases Data Capture & Analysis Non-Fiction Economics Econometrics Economic Statistics YOU HAVE ADDED AN ITEM TO YOUR WISHLIST Item Added: Analyzing Data with Power BI and Power Pivot for Excel View Wishlist CONTINUE SHOPPING SubscribeSubscribedUnsubscribe00 Loading Subscribe to newsletter

Note that we did not include in this list people who want to read a book about data modelingPASS Business Analytics Virtual Group 2,757 views 1:13:26 Analyze in Excel with the Power BI Data Model - Duration: 0:51May 17, 2017 2:10 PM Marco Russo (SQLBI) said: Thanks for the feedback! May 20, 2017 5:19 AM Data Imagineer said: Marco, I have been studying all of your works since 2013Looks greatThus, in a sentence if you are curious about what data modeling is and why it is a useful skill, then this is the book for youPlease try again laterWe tried to minimize the use of theoretical terms, trying to introduce with very practical examples and design patterns the terminology that is commonly used in data modeling (such as fact, dimensions, normalization, denormalization, star schema, snowflake schema, and so on)At this point, you might wonder why we did not include the words data modeling in the book title

Kaleigh Mulkey 402 views 0:51 Analyze Stock Market Daily, 50 Day, and 200 Day Trends with Power BI - Duration: 2:53Tags Business Intelligence Excel IT Pros New books PowerPivot Comments (1) Cancel reply Name * Email * Website inetguru says: July 2, 2017 at 2:30 pm The contents of the book is on topTechEd Europe 86,265 views 1:13:35 Live Power BI Demo - Facebook & Sentiment Analysis By Gil Raviv - Duration: 1:06:16He has particular competence and experience of BI solutions in sectors like financial services, manufacturing, commercial distribution and TV broadcastsThus, it could be useful (well, several models are really easy to implement as design patterns), but you should not learn new conceptsIf, on the other hand, you still need to learn DAX, then read The Definitive Guide to DAX, which is the most comprehensive guide to the DAX language and ties in well with the topics in this bookInstead, we focused on examples coming from our daily job as consultants

May 27, 2017 12:24 AM Marco Russo (SQLBI) said: Donald - thank you very much for the nice words! When you spot an error (even a grammatical one), please feel free to report it, so we can improve our writingsWe did not want to write a step-by-step bookIts not a big book at just over 200 pages but in some ways thats goodNihilent Technologies 1,990 views 2:53 Advanced Modeling and Calculations Using the Microsoft Power BI Designer - Duration: 1:13:35Next, they guide you to update and improve the model, so it can deliver the knowledge and insights you really needMicrosoft Power BI 1,456 views 40:33 See business analytics in action using Power BI, SQL Server 2016 BI, and Cortana Intelligence - Duration: 30:20I find your style comprehensible, with the odd exception of a broken grammatical rule here and there 07f867cfac



Hash Cakes: Space cakes, pot brownies and other tasty cannabis creationsProblems in Elementary Woodworking Graded for Instruction by the Group MethodMessen Mit Dem Analogen Messschieber (Unterweisung Zerspanungsmechaniker) (German Edition)Employee Timekeeping System: Large 8.5 Inches By 11 Inches Log Book To Track Time Activity Project or Task or Job IDAmerican Indian Dog Tricks Training American Indian Dog Tricks & Games Training Tracker & Workbook. Includes: American Indian Dog Multi-Level Tricks, Games & Agility. Part 3The Poor Student's Budget Booklet: A guide to saving money when studying.Modeling Structural Change in the U.S. Textile Industry (Studies on Industrial Productivity) Shu YangMentally-Deficient Children: Their Treatment and Training (Classic Reprint)Pacific Service Magazine, Vol. 18: July, 1930 (Classic Reprint)Mini Check Register Worksheet


Revenir en haut
Publicité






MessagePosté le: Ven 7 Juil - 16:03 (2017)    Sujet du message: Publicité

PublicitéSupprimer les publicités ?
Revenir en haut
Montrer les messages depuis:   
Poster un nouveau sujet   Répondre au sujet    ~VKY~ Index du Forum -> Forum PUBLIC -> Recrutement Toutes les heures sont au format GMT + 2 Heures
Page 1 sur 1

 
Sauter vers:  

Index | Panneau d’administration | forum gratuit | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation
Powered by phpBB © 2001, 2005 phpBB Group
Traduction par : phpBB-fr.com