Telecharger Pdf:

Introducing Microsoft Power Bi

Introducing Microsoft Power Bi. Ce sont les livres pour ceux qui cherchent à lire le Introducing Microsoft Power Bi, à lire ou à télécharger des livres Pdf / ePub et certains auteurs peuvent avoir désactivé la lecture en direct.Vérifiez le livre s'il est disponible pour votre pays et si l'utilisateur déjà abonné aura accès à tous les livres gratuits de la bibliothèque.

Introducing Microsoft Power BI

Telecharger pdf Introducing Microsoft Power BI

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. ...

  • L'auteur :
  • Editeur: Microsoft Press
  • ISBN: 1509302751
  • Genre: Computers
  • Nombre de pages: 189
  • Langue: French/English
  • Vues: 808
  • Telecharger: 808
  • GET BOOK AMAZON

Détails: 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/.


Analyzing Data with Power BI and Power Pivot for Excel

Telecharger pdf Analyzing Data with Power BI and Power Pivot for Excel

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 an ...

  • L'auteur : Alberto Ferrari,Marco Russo
  • Editeur: Microsoft Press
  • ISBN: 1509302816
  • Genre: Computers
  • Nombre de pages: 256
  • Langue: French/English
  • Vues: 344
  • Telecharger: 344
  • GET BOOK AMAZON

Détails: 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


Microsoft Power BI Dashboards Step by Step

Telecharger pdf Microsoft Power BI Dashboards Step by Step

Your hands-on guide to building effective Power BI dashboards Expand your expertise–and teach yourself how to create world-class Power BI business analys ...

  • L'auteur : Errin O'Connor
  • Editeur: Microsoft Press
  • ISBN: 0134894006
  • Genre: Computers
  • Nombre de pages: 304
  • Langue: French/English
  • Vues: 1682
  • Telecharger: 1682
  • GET BOOK AMAZON

Détails: 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


Beginning Microsoft Power BI

Telecharger pdf Beginning Microsoft Power BI

Analyze company data quickly and easily using Microsoft’s powerful data tools. Learn to build scalable and robust data models, clean and combine differen ...

  • L'auteur : Dan Clark
  • Editeur: Apress
  • ISBN: 1484256204
  • Genre: Computers
  • Nombre de pages: 411
  • Langue: French/English
  • Vues: 1330
  • Telecharger: 1330
  • GET BOOK AMAZON

Détails: Analyze company data quickly and easily using Microsoft’s powerful data tools. Learn to build scalable and robust data models, clean and combine different data sources effectively, and create compelling and professional visuals. Beginning Power BI is a hands-on, activity-based guide that takes you through the process of analyzing your data using the tools that that encompass the core of Microsoft’s self-service BI offering. Starting with Power Query, you will learn how to get data from a variety of sources, and see just how easy it is to clean and shape the data prior to importing it into a data model. Using Power BI tabular and the Data Analysis Expressions (DAX), you will learn to create robust scalable data models which will serve as the foundation of your data analysis. From there you will enter the world of compelling interactive visualizations to analyze and gain insight into your data. You will wrap up your Power BI journey by learning how to package and share your reports and dashboards with your colleagues. Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This third edition covers the new and evolving features in the Power BI platform and new chapters on data flows and composite models. This book is your hands-on guide to quick, reliable, and valuable data insight. What You Will Learn Simplify data discovery, association, and cleansing Build solid analytical data models Create robust interactive data presentations Combine analytical and geographic data in map-based visualizations Publish and share dashboards and reports Who This Book Is For Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data


Microsoft Power BI Quick Start Guide

Telecharger pdf Microsoft Power BI Quick Start Guide

Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights from your organization's data. This book will get you starte ...

  • L'auteur : Devin Knight,Brian Knight,Mitchell Pearson,Manuel Quintana
  • Editeur: Packt Publishing Ltd
  • ISBN: 1789130921
  • Genre: Computers
  • Nombre de pages: 202
  • Langue: French/English
  • Vues: 1147
  • Telecharger: 1147
  • GET BOOK AMAZON

Détails: Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights from your organization's data. This book will get you started with Business Intelligence using the Power BI tool, covering essential concepts like installation, building basic dashboards and visualizations to make your data come to life.


Mastering Microsoft Power BI

Telecharger pdf Mastering Microsoft Power BI

This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various ...

  • L'auteur : Brett Powell
  • Editeur: Packt Publishing Ltd
  • ISBN: 1788292286
  • Genre: Computers
  • Nombre de pages: 638
  • Langue: French/English
  • Vues: 848
  • Telecharger: 848
  • GET BOOK AMAZON

Détails: This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform effective visual analytics. By the end of this book, you will be able to gain unique, hidden insights into your data using Microsoft Power BI.


Power Pivot and Power BI

Telecharger pdf Power Pivot and Power BI

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible be ...

  • L'auteur : Rob Collie,Avichal Singh
  • Editeur: Tickling Keys, Inc.
  • ISBN: 1615473491
  • Genre: Computers
  • Nombre de pages: 271
  • Langue: French/English
  • Vues: 976
  • Telecharger: 976
  • GET BOOK AMAZON

Détails: Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages" whether they use a standard, fiscal, or a complete custom calendar. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.


Microsoft Power BI Cookbook

Telecharger pdf Microsoft Power BI Cookbook

Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploy ...

  • L'auteur : Brett Powell
  • Editeur: Packt Publishing Ltd
  • ISBN: 1788293789
  • Genre: Computers
  • Nombre de pages: 802
  • Langue: French/English
  • Vues: 1134
  • Telecharger: 1134
  • GET BOOK AMAZON

Détails: Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects. Style and approach This book consists of practical recipes on Power BI that target novices as well as intermediate Power BI users. It goes deep into the technical issues, covers additional protocols, and many more real-live examples.


Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Telecharger pdf Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI p ...

  • L'auteur : Daniil Maslyuk
  • Editeur: Microsoft Press
  • ISBN: 0134857798
  • Genre: Computers
  • Nombre de pages: 99998
  • Langue: French/English
  • Vues: 1147
  • Telecharger: 1147
  • GET BOOK AMAZON

Détails: Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI


Pro Power BI Desktop

Telecharger pdf Pro Power BI Desktop

Deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features, including c ...

  • L'auteur : Adam Aspin
  • Editeur: Apress
  • ISBN: 1484232100
  • Genre: Computers
  • Nombre de pages: 761
  • Langue: French/English
  • Vues: 1798
  • Telecharger: 1798
  • GET BOOK AMAZON

Détails: Deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features, including combo charts, Cartesian charts, trend lines, use of gauges, and more. Also covered are Top-N features, the ability to bin data into groupings and chart the groupings, and new techniques for detecting and handling outlier data points. You can take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease and then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft’s free self-service business intelligence tool. Pro Power BI Desktop shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You’ll be able to deliver those results on the PC, tablets, and smartphones, as well as share results via the cloud. This book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. What You'll Learn Deliver attention-grabbing information, turning data into insight Mash up data from multiple sources into a cleansed and coherent data model Create dashboards that help in monitoring key performance indicators of your business Build interdependent charts, maps, and tables to deliver visually stunning information Share business intelligence in the cloud without involving IT Deliver visually stunning and interactive charts, maps, and tables Find new insights as you chop and tweak your data as never before Adapt delivery to mobile devices such as phones and tablets Who This Book Is For Everyone from CEOs and Business Intelligence developers to power users and IT managers


Learn Power BI

Telecharger pdf Learn Power BI

Solve business challenges with Microsoft Power BI's advanced visualization and data analysis techniques Key Features Create effective storytelling reports ...

  • L'auteur : Greg Deckler
  • Editeur: Packt Publishing Ltd
  • ISBN: 1838646655
  • Genre: Computers
  • Nombre de pages: 362
  • Langue: French/English
  • Vues: 538
  • Telecharger: 538
  • GET BOOK AMAZON

Détails: Solve business challenges with Microsoft Power BI's advanced visualization and data analysis techniques Key Features Create effective storytelling reports by implementing simple-to-intermediate Power BI features Develop powerful analytical models to extract key insights for changing business needs Build, publish, and share impressive dashboards for your organization Book 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 learn Explore the different features of Power BI to create interactive dashboards Use the Query Editor to import and transform data Perform simple and complex DAX calculations to enhance analysis Discover business insights and tell a story with your data using Power BI Explore data and learn to manage datasets, dataflows, and data gateways Use workspaces to collaborate with others and publish your reports 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 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 Analysis with Microsoft Power BI

Telecharger pdf Data Analysis with Microsoft Power BI

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitl ...

  • L'auteur : Brian Larson
  • Editeur: McGraw Hill Professional
  • ISBN: 1260458628
  • Genre: Computers
  • Nombre de pages: N.A
  • Langue: French/English
  • Vues: 1455
  • Telecharger: 1455
  • GET BOOK AMAZON

Détails: Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. 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


Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Telecharger pdf Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI profes ...

  • L'auteur : Chris Sorensen
  • Editeur: Microsoft Press
  • ISBN: 1509308105
  • Genre: Computers
  • Nombre de pages: 99998
  • Langue: French/English
  • Vues: 1034
  • Telecharger: 1034
  • GET BOOK AMAZON

Détails: Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Microsoft Excel Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis


Introducing Microsoft SQL Server 2019

Telecharger pdf Introducing Microsoft SQL Server 2019

Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Key Features Gain insi ...

  • L'auteur : Kellyn Gorman,Allan Hirt,Dave Noderer,Mitchell Pearson,James Rowland-Jones,Dustin Ryan,Arun Sirpal,Buck Woody
  • Editeur: Packt Publishing Ltd
  • ISBN: 1838829822
  • Genre: Computers
  • Nombre de pages: 488
  • Langue: French/English
  • Vues: 1528
  • Telecharger: 1528
  • GET BOOK AMAZON

Détails: Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Key Features Gain insights into what’s new in SQL Server 2019 Understand use cases and customer scenarios that can be implemented with SQL Server 2019 Discover new cross-platform tools that simplify management and analysis Book Description Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. If you are looking to work with data processing and management, getting up to speed with Microsoft Server 2019 is key. Introducing SQL Server 2019 takes you through the latest features in SQL Server 2019 and their importance. You will learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. Further chapters will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server 2019. Dedicated sections in the book will also demonstrate how you can use SQL Server 2019 to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. By the end of this book, you'll be well versed with all the features of Microsoft SQL Server 2019 and understand how to use them confidently to build robust data management solutions. What you will learn Build a custom container image with a Dockerfile Deploy and run the SQL Server 2019 container image Understand how to use SQL server on Linux Migrate existing paginated reports to Power BI Report Server Learn to query Hadoop Distributed File System (HDFS) data using Azure Data Studio Understand the benefits of In-Memory OLTP Who this book is for This book is for database administrators, architects, big data engineers, or anyone who has experience with SQL Server and wants to explore and implement the new features in SQL Server 2019. Basic working knowledge of SQL Server and relational database management system (RDBMS) is required.


Microsoft Power BI Quick Start Guide

Telecharger pdf Microsoft Power BI Quick Start Guide

Microsoft Power BI Quick Start Guide, Second Edition gets you up to speed with Power BI quickly, enabling you to derive actionable insights from your data ...

  • L'auteur : Devin Knight,Mitchell Pearson,Bradley Schacht,Erin Ostrowsky
  • Editeur: Packt Publishing Ltd
  • ISBN: 1800569947
  • Genre: Computers
  • Nombre de pages: 294
  • Langue: French/English
  • Vues: 1272
  • Telecharger: 1272
  • GET BOOK AMAZON

Détails: Microsoft Power BI Quick Start Guide, Second Edition gets you up to speed with Power BI quickly, enabling you to derive actionable insights from your data using the data visualization capabilities of Microsoft Power BI within a short span of time.


Beginning Power BI

Telecharger pdf Beginning Power BI

Analyze your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, cl ...

  • L'auteur : Dan Clark
  • Editeur: Apress
  • ISBN: 1484225775
  • Genre: Business & Economics
  • Nombre de pages: 348
  • Langue: French/English
  • Vues: 1533
  • Telecharger: 1533
  • GET BOOK AMAZON

Détails: Analyze your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them with your colleagues. Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight. What You'll Learn Simplify data discovery, association, and cleansing Build solid analytical data models Create robust interactive data presentations Combine analytical and geographic data in map-based visualizations Publish and share dashboards and reports Who This Book Is For Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data


Beginning DAX with Power BI

Telecharger pdf Beginning DAX with Power BI

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of th ...

  • L'auteur : Philip Seamark
  • Editeur: Apress
  • ISBN: 1484234774
  • Genre: Computers
  • Nombre de pages: 264
  • Langue: French/English
  • Vues: 942
  • Telecharger: 942
  • GET BOOK AMAZON

Détails: Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. What You’ll Learn Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune Power BI to improve performance of your models Discover new ideas, tricks, and time-saving techniques for better models Who This Book Is For Business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios.


Power Query for Power BI and Excel

Telecharger pdf Power Query for Power BI and Excel

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft ...

  • L'auteur : Christopher Webb,Crossjoin Consulting Limited
  • Editeur: Apress
  • ISBN: 1430266929
  • Genre: Computers
  • Nombre de pages: 272
  • Langue: French/English
  • Vues: 957
  • Telecharger: 957
  • GET BOOK AMAZON

Détails: Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language


Pro Power BI Architecture

Telecharger pdf Pro Power BI Architecture

Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, develo ...

  • L'auteur : Reza Rad
  • Editeur: Apress
  • ISBN: 1484240154
  • Genre: Computers
  • Nombre de pages: 545
  • Langue: French/English
  • Vues: 585
  • Telecharger: 585
  • GET BOOK AMAZON

Détails: 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 Learn Architect 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


Building ERP Solutions with Microsoft Dynamics NAV

Telecharger pdf Building ERP Solutions with Microsoft Dynamics NAV

Create real-world enterprise solutions with NAV, Cloud, and the Microsoft stack About This Book Integrate NAV with various offerings of the Microsoft stack ...

  • L'auteur : Stefano Demiliani
  • Editeur: Packt Publishing Ltd
  • ISBN: 1787129640
  • Genre: Computers
  • Nombre de pages: 392
  • Langue: French/English
  • Vues: 973
  • Telecharger: 973
  • GET BOOK AMAZON

Détails: Create real-world enterprise solutions with NAV, Cloud, and the Microsoft stack About This Book Integrate NAV with various offerings of the Microsoft stack to create enterprise-ready and service-oriented solutions Use Power BI and Universal Windows Platform for effective data analysis and real-time tracking with NAV Discover the services offered by Microsoft Azure and implement them in different industries using real-world case scenarios Who This Book Is For This book is for NAV developers and solution architects who need to implement real-world enterprise solutions based on Microsoft Dynamics NAV. Knowledge of the NAV programming language (C/AL) and C# language is recommended. Knowledge of ASP.NET and Visual Studio development would help, but is not necessary. What You Will Learn Configure NAV Web Services and create external applications with Visual Studio, .NET, and .NET Core Solve technical architectural problems by implementing enterprise solutions with NAV Develop applications and solutions with Microsoft Dynamics NAV and the Microsoft technology stack Create a Power BI dashboard for rich reporting and NAV data analysis Find out how to transmit your device location from a UWP application to NAV in order to implement a distributed solution for managing couriers in a sales company Make the most of Microsoft Azure and its services Create enterprise solutions with NAV by using Azure App Service Use Azure Service Bus for managing distributed NAV applications In Detail Implementing Microsoft Dynamics NAV in the real world often requires you to integrate the ERP with external applications or solve complex architectural tasks in order to have a final successful project. This book will show you how to extend a Microsoft Dynamics NAV installation to the enterprise world in a practical way. The book starts with an introduction to Microsoft Dynamics NAV architecture and then moves on to advanced topics related to implementing real-world solutions based on NAV and external applications. You will learn how an enterprise distributed architecture with NAV at the core can be implemented. Through a series of real-world cases on every topic and every industry (sales, retail, manufacturing, distribution, healthcare, and so on), you'll see step by step how to efficiently solve a technical problem. These common problems encountered in a NAV implementation will be solved using the entire technology stack that Microsoft offers. By the end of the book, you will have the knowledge to efficiently solve certain scenarios, you will know which is the best solution architecture to propose to a customer and how to implement it. Style and approach Taking you through a variety of real-world use cases, the book will show you step by step all you need to know to tackle these problems and give you creative ideas to implement in related problems you might come across in the real world.


More Books Related