apbi2

APPLIED MICROSOFT POWER BI (2nd Edition)
 (BRING YOUR DATA TO LIFE!)

Applied Power BI (2nd Edition)Bring your data to life today and learn how Power BI changes the way everyone gains insights from data.

    • Publication date: 1/20/2017
    • Size: 380 pages, 7.5″ x 9.25″
    • Price: $49.99
    • ISBN 10: 0-9766353-7-2
    • ISBN 13: 978-0-9766353-7-6

new

 

 

 

Introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone, making it free to get started!

Power BI changes the way you gain insights from data; it brings you a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. It does so under a simple promise: “five seconds to sign up, five minutes to wow!”

“That is why resources like this fantastic book will become instrumental for you!”
Jen Underwood
Principal Program Manager
Microsoft Business Intelligence

Synopsis

An insightful tour that provides an authoritative yet independent view of this exciting technology, this guide introduces Microsoft Power BI—a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone, making it free to get started!

Information Workers will learn how to connect to popular cloud services to derive instant insights, create interactive reports and dashboards, and view them in the browser and on the go! Data Analysts will discover how to integrate and transform data from virtually everywhere and then implement sophisticated self-service models. The book also teaches BI and IT Pros how to establish a trustworthy environment that promotes collaboration, and they’ll implement Power BI-centric solutions for descriptive, real-time, and predictive analytics. Developers will find out how to integrate custom applications with Power BI, to embed reports, and to implement custom visuals to effectively present any data.

Ideal for both experienced BI practitioners and beginners, this book doesn’t assume you have any prior data analytics experience. It’s designed as an easy-to-follow guide that introduces new concepts with step-by-step instructions and hands-on exercises.


What’s inside

  • Get insights from popular cloud services on any device!
  • Implement sophisticated personal BI models!
  • Enable team BI and implement descriptive, predictive, and real-time BI solutions!
  • Extend Power BI with custom visuals and report-enable custom apps!
    …and much more!

Resources

Front matter Sample chapter (Chapter 1) Errata
Index Source code Forum
Back cover First edition page

Reviews

“The true power in Power BI cannot be appreciated without understanding what the offering can do and how to best use it. That is why resources like this fantastic book will become instrumental for you. This book starts by providing an overview of the foundational components of Power BI. It introduces Power BI Desktop, data modeling concepts, building reports, publishing and designing dashboards. Readers will be up and running in no time. It then moves on to bring you up to speed on deeper dive topics such as data gateways, data re-fresh, streaming analytics, embedding and the Power BI data visualization API. Not only is Teo one of the first people in the world to learn and write about Power BI 2.0, he also brings a wealth of knowledge from deploying the first real-world implementations. Much like Teo’s previous books on Analysis Services and Reporting Services, this Power BI book will be a must read for serious Microsoft professionals. It will also empower data analysts and enthusiasts everywhere.”

Jen Underwood
Principal Program Manager, Microsoft Business Intelligence

“I’m impressed about the breadth of the topics covered by Teo Lachev in this book, I’ve just took a quick look at every chapter, and Teo covered all the topics at least at the point where you can start doing something (and in some chapter also more than just an intro). Considering the speed of Power BI releases and the effort required in writing a book, I know the huge effort behind this. My kudos to this book!”

Macro Russo
Consultant, SQLBI

How to purchase

Buy the paper copy from Amazon
Buy the Kindle ebook from Amazon

 

book1

APPLIED MICROSOFT POWER BI
 (BRING YOUR DATA TO LIFE!)

book1Bring your data to life today and learn how Power BI changes the way everyone gains insights from data.

    • Publication date: 1/1/2016
    • Size: 314 pages, 7.5″ x 9.25″
    • Price: $44.95
    • ISBN 10: 0-9766353-6-4
    • ISBN 13: 978-0-9766353-6-9

Introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone, making it free to get started!

There is a newer edition of this book

Power BI changes the way you gain insights from data; it brings you a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. It does so under a simple promise: “five seconds to sign up, five minutes to wow!”

“That is why resources like this fantastic book will become instrumental for you!”
Jen Underwood
Principal Program Manager
Microsoft Business Intelligence

Synopsis

An insightful tour that provides an authoritative yet independent view of this exciting technology, this guide introduces Microsoft Power BI—a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone, making it free to get started!

Information Workers will learn how to connect to popular cloud services to derive instant insights, create interactive reports and dashboards, and view them in the browser and on the go! Data Analysts will discover how to integrate and transform data from virtually everywhere and then implement sophisticated self-service models. The book also teaches BI and IT Pros how to establish a trustworthy environment that promotes collaboration, and they’ll implement Power BI-centric solutions for descriptive, real-time, and predictive analytics. Developers will find out how to integrate custom applications with Power BI, to embed reports, and to implement custom visuals to effectively present any data.

Ideal for both experienced BI practitioners and beginners, this book doesn’t assume you have any prior data analytics experience. It’s designed as an easy-to-follow guide that introduces new concepts with step-by-step instructions and hands-on exercises.


What’s inside

  • Get insights from popular cloud services on any device!
  • Implement sophisticated personal BI models!
  • Enable team BI and implement descriptive, predictive, and real-time BI solutions!
  • Extend Power BI with custom visuals and report-enable custom apps!
    …and much more!

Resources

Front matter Sample chapter (Chapter 1) Errata
Index Source code Forum
Back cover

Reviews

“The true power in Power BI cannot be appreciated without understanding what the offering can do and how to best use it. That is why resources like this fantastic book will become instrumental for you. This book starts by providing an overview of the foundational components of Power BI. It introduces Power BI Desktop, data modeling concepts, building reports, publishing and designing dashboards. Readers will be up and running in no time. It then moves on to bring you up to speed on deeper dive topics such as data gateways, data re-fresh, streaming analytics, embedding and the Power BI data visualization API. Not only is Teo one of the first people in the world to learn and write about Power BI 2.0, he also brings a wealth of knowledge from deploying the first real-world implementations. Much like Teo’s previous books on Analysis Services and Reporting Services, this Power BI book will be a must read for serious Microsoft professionals. It will also empower data analysts and enthusiasts everywhere.”

Jen Underwood
Principal Program Manager, Microsoft Business Intelligence

“I’m impressed about the breadth of the topics covered by Teo Lachev in this book, I’ve just took a quick look at every chapter, and Teo covered all the topics at least at the point where you can start doing something (and in some chapter also more than just an intro). Considering the speed of Power BI releases and the effort required in writing a book, I know the huge effort behind this. My kudos to this book!”

Macro Russo
Consultant, SQLBI

How to purchase

Buy the paper copy from Amazon
Buy the Kindle ebook from Amazon

 

book2

APPLIED MICROSOFT SQL SERVER 2012 ANALYSIS SERVICES
 (TABULAR MODELING)

book2Learn how to implement rapid solutions for personal, team, and organizational BI.

  • Publication date: 3/1/2012
  • Size: 416 pages, 7″ x 9 1/4″
  • Price: $49.95
  • ISBN 10: 0-9766353-5-6
  • ISBN 13: 978-0-9766353-5-2

Introduces the Tabular side of the innovative Business Intelligence Semantic Model (BISM) that promotes rapid professional and self-service BI application development.

Business analysts and power users will learn how to integrate data from multiple data sources, implement self-service BI applications with Excel, and deploy them to SharePoint. Business intelligence professionals and database administrators will discover how to build corporate solutions powered by BISM Tabular, delivering supreme performance with large data volumes, and how to implement a wide range of solutions for the entire spectrum of personal-team-organizational BI needs.


Synopsis

An insightful tour that provides an authoritative yet independent view of this exciting technology, this guide introduces the Tabular side of the innovative Business Intelligence Semantic Model (BISM) that promotes rapid professional and self-service BI application development. Business analysts and power users will learn how to integrate data from multiple data sources, implement self-service BI applications with Excel, and deploy them to SharePoint. Business intelligence professionals and database administrators will discover how to build corporate solutions powered by BISM Tabular, delivering supreme performance with large data volumes, and how to implement a wide range of solutions for the entire spectrum of personal-team-organizational BI needs.

Ideal for experienced BI professionals or beginners, this book features step-by-step instructions and demos for building reports and dashboards, deploying and managing tabular models, and integrating data from various sources. The online video tutorials include over 3 hours of recorded content that demonstrates selected book exercises.


What’s inside

  • Implement personal BI models with PowerPivot for Excel
  • Share PowerPivot models and gain insights with PowerPivot for SharePoint
  • Implement scalable and secure organizational models with Analysis Services Tabular

Resources

Front matter Sample chapter (Chapter 1) Errata
Index Source code Old Forum
Back cover Video demos

Reviews

“This is a great book for getting up and running quickly with the new tabular data model available in SQL Server Analysis Services 2012. I was able to read this book fairly quickly, good for a busy IT Professional. The book covers PowerPivot, PowerView, and the various ways to create the new tabular projects. If you are looking for something that will cover all aspects of the new tabular abilities in SSAS 2012, I’d recommend this book without hesitation.”

Robert Cain
SQL Server MVP

“Many IT Professionals getting started with PowerPivot for Excel , PowerPivot for SharePoint or Analysis Services in Tabular mode will find this is the only book they need to launch their first successful Tabular project.”

Rob Kerr
SQL Server MVP

“I have had the chance to read Teo’s books over the years, and they happen to be insightful, detailed and more than anything, absolutely helpful. This one is no exception, and keeps the bar on tradition with the high quality you expect. Teo is one of those authors that I use to reference when after, one of my conferences, someone asks me for a good comprehensive book on Microsoft’s BI stack. Mix this one with Alberto and marco on DAX and you will be ready for some fun.”

Alejandro Leguizamo
SQL Server MVP

How to purchase

We don’t offer an e-book version of this book at this point.

 

 

book3

MCTS SELF-PACED TRAINING KIT
 (EXAM 70-448)

book3Your 2-in-1 Self-Paced Training Kit features official exam prep and practice for the skills measured by Exam 70-448.

  • Published: 4/5/2009
  • Size: 688 pages, 7″ x 9 1/4″
  • Price: $69.99
  • ISBN 13: 9780735626362

features official exam prep and practice for the skills measured by Exam 70-448. Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job.Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs.


Synopsis

Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.


What’s inside

  • Create SSIS packages; troubleshoot data flow and control flow
  • Configure, debug, and deploy SSIS solutions
  • Develop SSAS cubes for OLAP and data mining services
  • Implement custom logic with MDX
  • Optimize storage design and query performance
  • Create SSRS reports; enable interactivity; write custom code

How to purchase

 

book41

APPLIED MICROSOFT SQL SERVER 2008 REPORTING SERVICES

book41

teaches you how to apply Reporting Services in real life to build innovative Business Intelligence solutions that drive decisions. The author, who has worked closely with the Reporting Services Development Team, takes you on an insightful tour that provides an authoritative yet independent view of the technology. The book is designed as an easy-to-follow guide for navigating safely the most intricate aspects of the technology.“…a great resource for those who are looking to get the most out of the Microsoft reporting platform.”

Brian Welcker
Former Group Program Manager
Microsoft SQL Server Reporting Services

Synopsis

Supplying much-needed technological information to workers, administrators, and developers, APPLIED MICROSOFT SQL SERVER 2008 REPORTING SERVICES shows you how to apply Reporting Services in real life to build innovative Business Intelligence solutions that drive decisions. Information workers will learn how to design feature-rich standard and ad hoc reports. The book gives administrators the necessary background to install, upgrade, and manage the report environment. It teaches developers ways to extend Reporting Services to bend it to their needs and integrate it with a wide range of applications.

The book doesn’t assume any prior experience with Microsoft Reporting Services. It is designed as an easy-to-follow guide for navigating safely the most intricate aspects of the technology. New concepts are introduced with step-by-step instructions and hands-on lessons. Video presentations help the reader stay on track when a picture is worth more than a thousand words.


What’s inside

  • Author professional standard and ad hoc reports
  • Install, upgrade, and manage the report environment
  • Integrate Reporting Services with custom application, Analysis Services, and SharePoint
  • Extend Reporting Services in versatile ways

Resources

Front matter Sample chapters (1 and 3) Errata
Index Source code Old Forum
Back cover Video demos

Reviews

“Applied Microsoft Reporting Services is a great resource for those who are looking to get the most out of the Microsoft reporting platform. Leveraging his lengthy experience with the product and close relationship with the development team at Microsoft, Teo provides an insider’s view of the product that goes beyond simple tutorials and screenshots. The book has a wealth of information about little known areas of the product and is loaded with practical examples that will save you time and frustration during your next reporting project.”

Brian Welcker
Former Group Program Manager
Microsoft SQL Server Reporting Services

“…All in all, then, a very highly recommended book; it’s ideal for both beginners and experienced developers and probably the only Reporting Services 2008 book you’ll ever need.”

Chris Webb
Microsoft MVP and CEO of Crossjoin Consulting
View the full review here

“…Those who are familiar with Teo’s previous books will not be disappointed with his latest work – Applied Microsoft SQL Server 2008 Reporting Services.”

Nick Barclay
Microsoft SQL MVP and BI Consultant
View the full review here

“Very well written and thorough… plus great examples. I think what I like best about Teo’s book is that he is such a great writer and knows how to organize content that makes sense and is structured in the right way.”

Erik Veerman
Microsoft SQL MVP and Solid Quality Mentor
View the full review here

How to purchase

 

book5

MCTS SELF-PACED TRAINING KIT
 (EXAM 70-445)

book5Your 2-in-1 Self-Paced Training Kit features official exam prep and practice for the skills measured by Exam 70-445.

  • Published: 4/5/2009
  • Size: 688 pages, 7″ x 9 1/4″
  • Price: $69.99
  • ISBN 13: 9780735626362

features official exam prep and practice for the skills measured by Exam 70-445. Ace your preparation for the skills measured by MCTS Exam 70-445—and on the job.

Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs.


Synopsis

Ace your preparation for the skills measured by MCTS Exam 70-445—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.


What’s inside

  • Create SSIS packages; troubleshoot data flow and control flow
  • Configure, debug, and deploy SSIS solutions
  • Develop SSAS cubes for OLAP and data mining services
  • Implement custom logic with MDX
  • Optimize storage design and query performance
  • Create SSRS reports; enable interactivity; write custom code

How to purchase

 

book4

Applied Microsoft Analysis Services 2005

book4A guide to the leading OLAP Platform – Microsoft Analysis Services.

  • Published: 12/1/2005
  • Size: 712 pages, 7″ x 9 1/4″
  • Price: $49.95
  • ISBN: 0976635305

It teaches you how to build end-to-end OLAP solutions with Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform. This book doesn’t assume any prior experience with OLAP and Microsoft Analysis Services. It is designed as an easy-to-follow guide where each chapter builds upon the previous to implement the components of the innovative Unified Dimensional Model (UDM). New concepts are introduced with step-by-step instructions and hands-on labs.


Synopsis

APPLIED MICROSOFT ANALYSIS SERVICES 2005 shows database administrators and developers how to build end-to-end OLAP solutions with Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform. Database administrators will learn how to design and manage sophisticated OLAP cubes that provide rich data analytics and data mining services.

The book gives database developers the necessary background to extend UDM with custom programming logic, in the form of MDX expressions, scripts and .NET code. It teaches them how to implement a wide range of reporting applications that integrate with Analysis Services, Reporting Services, and Microsoft Office.

This book doesn’t assume any prior experience with OLAP and Microsoft Analysis Services. It is designed as an easy-to-follow guide where each chapter builds upon the previous to implement the components of the innovative Unified Dimensional Model (UDM). New concepts are introduced with step-by-step instructions and hands-on labs.


What’s inside

  • Design and build the UDM
  • Implement data warehousing and mining solutions
  • Extend UDM programmatically with MDX
  • Manage Analysis Services
  • Build reporting solutions

Inside the book

Front cover Sample chapters (1 and 7) Source code
Table of contents Index Errata
Preface Back cover Old Forum

How to purchase

 

book6

Microsoft Reporting Services in Action

book6

Bring Microsoft Reporting Services 2000 to the next level!

  • Published: 8/1/2004
  • Size: 656 pages, 7.4″ x 9 1/4″
  • Price: $49.95
  • ISBN: 1932394222

It is a detailed and practical guide to the functionality provided by Microsoft Reporting Services 2000. It systematically shows off many powerful RS features by leading you through a dizzying variety of possible uses. Following a typical report lifecycle, the book shows you how to create, manage, and deliver RS reports.“I encourage you to use the ideas in this book and take Reporting Services to the next level.”

Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

Synopsis

I have been cherishing the idea of writing a book on .NET since my initial encounter with .NET when I was involved in the .NET early adopter program. Towards the end of 2003, the planets were aligned in my favor and I was thinking seriously about how to materialize this idea. Initially, I was planning to write a book on WinForm development which would walk the reader through the implementation lifecycle of a distributed WinForm application.

Around that time, I got my hands on a beta 1 copy of Reporting Services and was immediately hooked. No matter what application you are implementing right now, chances are it manipulates data of some sort. The problem with data, though, is that you always have too much of it. For this reason, reporting is an integral part of every complete business application. Yet, report-enabling applications is often regarded as a tedious chore. Microsoft SQL Server 2000 Reporting Services changes all of this.

Reporting Services (RS) is a great piece of technology. With RS, report authors can create reports as easily as you would do it in Microsoft Access. But make no mistake. Reporting Services is a sophisticated server-based oriented platform and its feature set goes well beyond that of a desktop reporting tool. To use RS effectively, you need to have a solid grasp of how it works and how it can be integrated with different types of client applications. I hope this book makes this endeavor easier.

While I contemplated what the book scope will be, it dawned on me that I could bring the most value by following my heart and approaching Reporting Services from a developer’s point of view. I put myself in a position that many developers could relate to. Here I am as a developer, consultant, architect, who is tasked with adding reporting features to a given application. How would I do this?

To reflect this idea, my book takes a solution-oriented approach and more than half of it is devoted on integrating different types of applications with Reporting Services. While you are reading the book, you will find a common pattern. It starts by discussing the requirements and design goals of a given reporting scenario. Then, it discusses the implementation choices, and, finally, it explains how the solution is implemented.


What’s inside

  • Extend RS with custom code to add report forecasting
  • Expose reports as RSS feeds
  • Develop a WinForm-based Report Wizard
  • Write an ASP.NET web control for client and server-side report generation
  • Create reports off ADO.NET datasets
  • Deliver reports to Web Services
  • Customize RS security
  • Evaluate RS performance and capacity
  • and much more…

Inside the book

Table of contents Chapters (1 and 6) Errata
Foreword Index Book reviews
Preface Source code Old Forum

 


 

How to purchase