With the increasing importance on business intelligence tools in today’s business environment, it’s important to know the difference between products. Especially because many product vary widely in price, but can sometimes offer similar functionality. For instance, two popular BI tools, Tableau and PowerPivot (from Microsoft) have many comparable features but one (depending on the version and functionality you need) is free (that would be PowerPivot.) While the other, Tableau can cost in the thousands of dollars – again, depending on the version and functionality you need.
Luckily, there are several great sites that have compared PowerPivot and Tableau and provide a great overview of the difference between the two in terms of versions and funcationality. If you’re considering a BI tool for your organization and PowerPivot and Tableau are on your list, check out these sites to compare the two:
Microsoft PowerPivot vs. Tableau (link from SQLMag.com)
Tableau vs. Power Pivot Part 1: Basic Functionality (link from breaking-bi.blogspot.com)
Tableau vs. Power Pivot: Basic Charting (link from breaking-bi.blogspot.com)
Tableau vs. Power Pivot: Basic Data Modeling (link from breaking-bi.blogspot.com)
Tableau vs. Power Pivot: KPIs (link from breaking-bi.blogspot.com)
- Download SQL Server Express 2008 R2 SP1 – Express Edition from http://www.microsoft.com/en-us/download/details.aspx?id=26729
- Click the Download button.
- If prompted, select “No, I do not want to register. Take me to the download” and click the Next button.
- Select SQLEXPRWT_x64_ENU.exe if you are running a 64 bit operating system, or SQLEXPRWT_x86_ENU.exe if you are running a 32 bit operating system. If you are not sure which operating system you are running go to Windows Explorer, right-click on “My Computer” and choose “Properties.” Your system type will be displayed.
- After selecting the appropriate file, click the Next button.
- Save the downloaded file to a location you will remember.
- Once downloaded, launch the installation file exe.
- From the SQL Server Installation Center, select “New Installation or add features to an existing installation.
- Accept the license terms and click the Next button.
- All features should be selected by default, but if not, click the Select All button and click the Next button.
- Accept the Named Instance in the Instance Configuration dialog and click the Next button.
- Click the Next button on the Server Configuration dialog.
- Select “Mixed Mode” under Authentication Mode and enter a password of cr2008 for the sa account. Re-enter the password in the Confirm Password field and click the Next button.
- Click the Next button on the Error Reporting dialog.
- Click the Close button once the installation is complete.
- Install the course files, including the database you will be using in class by clicking here.
- Once the zip file has downloaded, extract the files to the root of your C:\ drive.
- Open Windows Explorer and navigate to the location: C:\CR2008 D3 Class Resources\Databases
- Right-click on the AdventureWorks_Data.mdf file and select Properties.
- Depending on your Windows configuration, the file may be blocked because you downloaded it from the internet. If this is the case, you will see a security message at the bottom of the General Tab in the Properties dialog box alerting you to this. Click the Unblock button and then click the Apply button.
- Click the Security Tab in the Properties dialog.
- Select the Authenticated Users group from the Group or User Names list.
- Click the Edit button.
- In the Permissions dialog box, check the Allow box next to Full Control. Click the OK button to close the dialog.
- Click the OK button to close the Properties dialog.
- Repeat steps 19-25 with the Adventure_Works_Log.ldf file in the same directory.
- From the Windows Start Menu, under All Programs, open Microsoft SQL Server Management Studio (which may be located under the parent folder Microsoft SQL Server 2008 R2)
- In the Connect to Server dialog, click the Connect button.
- In the Object Explorer Pane, right-click on the Databases folder and select Attach.
- In the Attach Databases dialog, click the Add button.
- In the Locate Database Files dialog, navigate to the C:\CR2008 D3 Class Resources\Databases directory and select the AdventureWorks_Data.mdf files. Then click the OK button.
- Click OK again if you receive a notification about Catalogs.
- Once the Attach succeeds, you should see the AdventureWorks database listed under the Databases folder in Microsoft SQL Server Management Studio.
- You can now close Microsoft SQL Server Management Studio.
If you’ve ever inherited a database someone else created in Microsoft Access you may have run across the dreaded “hidden-table” scenario. This is when the original developer of the database has hidden (probably in an effort to keep anyone from disturbing them) the source tables that contain your data from the Navigation Pane in Microsoft Access. You’ll realize this has happened, typically, because you’ll go to create a query and you’ll see a tables or tables as being available to include in your query, but strangely, you don’t see those same tables listed in the Navigation Pane in Access. To fix this problem in Microsoft Access 2010 you can:
- Right-click on the title of the Navigation Pane (It probably displays the words “All Access Objects” but may say “Tables” or “Queries,” etc. if you have changed your Navigation Pane View.
- Click on “Navigation Options” from the shorcut menu.
- In the Navigation Options dialog box, check the option to “Show Hidden Objects”
- The hidden Access tables should now appear, but are “grayed out.” You can still open them, but to unhide them permanently, right-click on the table you want to unhide and select “Unhide in this Group”
In this free Microsoft Access tutorial, you’ll see how to link tables in a Microsoft Access 2010 Query. You’ll also learn the difference between inner joins, left outer joins and right outer joins. Learn more about Microsoft Access in our Microsoft Access Training courses.
Adobe Photoshop CC, Dreamweaver CC and InDesign CC are part of Creative Cloud™. In our free webinar series, you will learn some of new features in each of these products. You’ll also learn how Creative Cloud enables you to have access to all the latest updates and future releases the moment they’re available. Attend these free webinars to see some of the dozens of new features in Adobe Photoshop CC, Adobe Dreamweaver CC and Adobe InDesign CC and learn more about how Creative Cloud is changing the way Adobe updates and releases software products! Visit Free Adobe CC Webinars to learn more and register!
SkillForge is happy to announce QlikView Training – offered both as live, onsite classes and live, online classes. Business Intelligence is a major area of interest to most companies these days. With data stored in multiple different sources (mainframes, client server databases, etc.) – the idea of a simple “dashboard” for executives and managers to quickly analyze key performance indicators is very attractive. There are several tools in the market that can assist in building these dashboards, including Crystal Dashboard Design, SharePoint and QlikView.
QlikView can be used for all types of reporting, forecasting, and general data analysis of virtually any type of information (e.g., GA, AR, AP, sales, inventory, estimates, trends, etc.). And because it allows end users to interact with the data, QlikView (despite its categorization as business software) can also be used in any field where real-time data analysis is needed (e.g., science, engineering, academic research, art, etc.). QlikView can be deployed on premise, cloud servers, laptops, mobile devices like iPhones and iPads, and for single users to large enterprises.
This Adobe Captivate tutorial shows how to create a quiz in Adobe Captivate 6. You will see how to add a question slide to a Captivate project and how to track a user’s success or failure. In addition you will see how to use multiple choice and true/false questions in an Adobe Captivate quiz. This tutorial is from our live, instructor-led Adobe Captivate 6 Training course.
In this Microsoft Access Tutorial, you’ll see how to begin using VBA in Microsoft Access 2007. The basic concepts of objects, properties methods and events are explained and then you will see how to attach VBA code to the load event of a Microsoft Access Form and to the click event of a Command Button on a form. This tutorial is from our live, instructor-led online course: Microsoft Access 2007 VBA Training course. To learn more, visit our Microsoft Access Courses Page.
In this Microsoft Access Tutorial you’ll see how to connect to a database using ADO Connection, Command and Recordset objects in VBA code, how to populate text boxes from fields in the data retrieved, and how to create command buttons that use ADO Recordset methods to allow the user to move throughout the data. This content is from our live, instructor-led online MIcrosoft Access 2007 VBA Training course. To learn more, visit our Microsoft Access Courses Page.