Power BI Data Analysis and Visualization
Home > Computing and Information Technology > Databases > Data mining > Power BI Data Analysis and Visualization
Power BI Data Analysis and Visualization

Power BI Data Analysis and Visualization


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Power BI Data Analysis and Visualization provides a roadmap to vendor choices and highlights why Microsoft’s Power BI is a very viable, cost effective option for data visualization. The book covers the fundamentals and most commonly used features of Power BI, but also includes an in-depth discussion of advanced Power BI features such as natural language queries; embedding Power BI dashboards; and live streaming data. It discusses real solutions to extract data from the ERP application, Microsoft Dynamics CRM, and also offers ways to host the Power BI Dashboard as an Azure application, extracting data from popular data sources like Microsoft SQL Server and open-source PostgreSQL. Authored by Microsoft experts, this book uses real-world coding samples and screenshots to spotlight how to create reports, embed them in a webpage, view them across multiple platforms, and more. Business owners, IT professionals, data scientists, and analysts will benefit from this thorough presentation of Power BI and its functions.

Table of Contents:
Chapter 1: Introducing Data Visualization  1 Overview of Technology  1 Importance of Data Visualization  1 Data Visualization Tools  2 Understanding Power BI  2 Comparing Microsoft Power BI and Tableau  3 Key Features of Power BI  4 Sign Up for Free  5 Receive Data from Multiple Data Sources  5 Obtain Key Metrics of Your Business  5 Quick Insights  5 Data-Driven Decision Making from Anywhere  6 Advanced Features of Power BI  6 Embed Power BI Reports and Dashboards into a Web App  6 Real-Time Streaming  6 Support for Natural Language Query  6 Share Content Pack  7 Integration with Cortana  7 Variants of Power BI  7 Power BI Desktop  7 Power BI Service  30 Publishing a Report  38 Summary  41 Chapter 2: Power BI Azure Application  43 Embedding Power BI Reports into a Web App  43 Real-Time Streaming  47 Exploring Real-Time Streaming Datasets  47 Different Ways of Pushing Data  48 Viewing Real-Time Streaming of Data  48 Quick Insights  58 Summary  64 Chapter 3: Power BI on Microsoft Stack  65 Getting Data into Power BI from SQL Server  65 Using the Import Option  65 Using the DirectQuery Option  69 Data Modeling  74 Creating Relationships Among Tables  74 Using Data Analysis Expressions  82 Using Calculated Columns  84 Using Calculated Tables  86 Creating a Report  88 Creating a Report Using the DirectQuery Option  89 Creating a Report Using the Import Option  95 Saving the Report  96 Publishing the Report  98 Gateway Setup  100 Understanding Gateways  100 Types of Gateways  100 Downloading and Installing the On-Premises Data Gateway  101 Configuring Gateway  107 Adding a Data Source  110 Natural Language Querying  116 Data Refresh in Power BI  123 Configuring Scheduled Refresh  124 Creating Content Packs  129 Power BI Integration with Cortana Suite  133 Creating a Cortana Answer Page and Publishing It  133 Enabling Cortana to Access the Dataset  136 Adding Power BI Credentials to Windows 10  140 Accessing the Report through Cortana  144 Summary  149 Chapter 4: Power BI on Open Source Stack  151 Integrating PostgreSQL with Power BI  151 Downloading and Installing Npgsql Connector  151 Getting Data into Power BI  155 Data Modeling  158 Creating Relationship between Tables  159 Data Analysis Expressions  162 Creating a Calculated Column  163 Creating a Report  165 Saving the Report  185 Publishing the Report  186 Data Refresh in Power BI  188 Setting Up Scheduled Refresh  189 Creating Content Packs  204 Summary  210 Chapter 5: Power BI on ERP Applications  211 Defining CRM  211 Functions of a CRM Solution  211 Microsoft Dynamics CRM  212 Benefits of Microsoft Dynamics CRM  212 Sign Up for Microsoft Dynamics CRM Online  213 Creating Sample Data for Dynamics CRM  217 Getting Data into Power BI  219 Creating Reports  222 Leads Revenue by Employee  222 Leads Revenue by Company  228 Loans by Category  230 Loans Summary  231 Deep Linking in Power BI  233 Adding a New User  233 Row-Level Security in Power BI  237 Defining Roles and Rules  238 Validating the Role within Power BI Desktop  240 Deploying the Report  242 Managing Security  242 Working with Members  244 Validating the Role within Power BI Service  246 Sharing the Report  247 Summary  249 Chapter 6: Conclusion  251 Introducing Data Visualization  251 Power BI Azure Application  252 Power BI on Microsoft Stack  252 Power BI on Open Source Stack  253 Power BI on ERP Applications  254 Index  255

About the Author :
Suren Machiraju is Technical Business Partner with the Bill & Melinda Gates Foundation where he provides technology guidance and designs software solutions to help partners achieve organization objectives. Previously he was Engineering Manager, Azure Services at Microsoft; the founding member/manager of the Azure Customer Advisory Team; and Group Program Manager of the Connected Systems, Windows Server Customer Advisory Team. He is an innovator with over 20 patents relating to Electronic Document Interchange and Transport Protocols. Suraj Gaurav is a cloud technologist and previously worked at Microsoft as Principal Engineering Manager where he led a team of talented engineers who built and ran the Exchange datacenter services. Prior to that, he worked on the Commerce Platform where he designed the first consumption based billing model for Microsoft which was used by Azure for its commercial launch in February 2010. Suraj specializes in cloud services, commerce transactions, B2B messaging, EDI, and healthcare protocols.


Best Sellers


Product Details
  • ISBN-13: 9781547400744
  • Publisher: De Gruyter
  • Publisher Imprint: De|G Press
  • Language: English
  • ISBN-10: 1547400749
  • Publisher Date: 10 Sep 2018
  • Binding: Digital (delivered electronically)
  • No of Pages: 287


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Power BI Data Analysis and Visualization
De Gruyter -
Power BI Data Analysis and Visualization
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Power BI Data Analysis and Visualization

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!