Part 5 – Importing a CSV file into SharePoint 2013: Create Home Page Dashboards

Home > Blogs > SharePoint > Part 5 – Importing a CSV file into SharePoint 2013: Create Home Page Dashboards

Part 5 – Importing a CSV file into SharePoint 2013: Create Home Page Dashboards

Like This Blog 1Spike Xavier
Added by October 5, 2016

SharePoint Video Training Series – Importing a CSV file into SharePoint 2013.

  1. Introduction
  2. Prepare the Excel File
  3. Create the List in SharePoint 2013
  4. Create the Views in SharePoint 2013
  5. Create the SharePoint Home Page Dashboard

For instructor-led SharePoint training, see our class schedule.

This is the fifth and final video in our SharePoint training series and really where we get to get all the payoff. We’re going to create some dashboards.

Download the Products.csv file.

Now, these are not PerformancePoint dashboards or Excel Web Access dashboards. These are dashboards using out of the box wiki pages on a SharePoint team site, and some views that we created in order to let users see what they need to see very easily without having to know any programming or JavaScript or anything like that.

I’m on my site here, my products site.

001-how-to-create-home-page-dashboards-in-sharepoint-2013

I’ll click the link and go to the home page. I have that products list that I’ve been working with.

002-how-to-create-home-page-dashboards-in-sharepoint-2013

What I’m going to do is simply click the gear and say Add a Page.

003-how-to-create-home-page-dashboards-in-sharepoint-2013

Now, because this is a site that was based on the team side template, it’s going to put my page in the site pages library. I’m just going to name this ProductsByDepartment.

004-how-to-create-home-page-dashboards-in-sharepoint-2013

I’ll click Create, and it’s going to go ahead and create my page for me. It’s a blank wiki page, it goes right into edit mode.

005-how-to-create-home-page-dashboards-in-sharepoint-2013

I’m going to insert an App Part, because it’s from our products app, which list an app that are used the same in this context.

006-how-to-create-home-page-dashboards-in-sharepoint-2013

I’ll select Products and click Add.

007-how-to-create-home-page-dashboards-in-sharepoint-2013

It’s going to add all the items, the view of all the items,

008-how-to-create-home-page-dashboards-in-sharepoint-2013

While it’s in edit mode, I’m going to click what I refer to as the black UFO triangle right there. I’m going to click that black UFO triangle and I’m going to say Edit Web Part.

009-how-to-create-home-page-dashboards-in-sharepoint-2013

This will take me to the Web Part properties section or little area here on the right side.

010-how-to-create-home-page-dashboards-in-sharepoint-2013

Sometimes you have to scroll over, depending on your resolution. I’m going to bind this Web Part to my by Department view and I’ll click OK.

011-how-to-create-home-page-dashboards-in-sharepoint-2013

That’s the view that we created in the last video, that groups all the products by department.

013-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to change, in the appearance. From the word Products I’m going to call it Products by Department

012-how-to-create-home-page-dashboards-in-sharepoint-2013

You can actually edit the title of the Web Part.

Finally I’ll click OK,

014-how-to-create-home-page-dashboards-in-sharepoint-2013

And without any custom coding whatsoever I’ve got a SharePoint page which I’m going to call a dashboard, that shows all the products, by department.

015-how-to-create-home-page-dashboards-in-sharepoint-2013

If I expand those.

016-how-to-create-home-page-dashboards-in-sharepoint-2013

We can see where you can actually go in and set the settings of a view to open already expanded, but in this case it would be a lot of products and you’ll get paging, so this probably is a really useful way to do it. You’ll have to decide what makes sense in your organization.

You may also like:  Using Navigation Controls in a Collaboration Site in SharePoint

Now I’ve got a page of ProductsByDepartment and I can expand them all by applying a view to a Web Part Properties on a page.

The second dashboard that I’m going to create is just going to have a few more Web Parts on it. It is going to have products under $50, products $50 to $100, and products over $100.

Again I’m going to say Site Actions, Add a Page.

017-how-to-create-home-page-dashboards-in-sharepoint-2013

Then, add a title of ProductsByPrice.

018-how-to-create-home-page-dashboards-in-sharepoint-2013

SharePoint will automatically add .ASPX.

I’m going to click the Insert tab because it opens in the edit mode and App Part,

019-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to click Products and Add

020-how-to-create-home-page-dashboards-in-sharepoint-2013

Then Insert, App Part then Add

021-how-to-create-home-page-dashboards-in-sharepoint-2013

It should fill that I was selecting Products the last time.

Again repeat the same process one last time. Insert, App Part, Products, and Add.

Now I’ve added three Web Parts to this page. They’re all using the same view, so it’s a long page at this point, but it’s still in edit mode. Now on the top Web Part I’m going to click the black triangle.

022-how-to-create-home-page-dashboards-in-sharepoint-2013

And then select “Edit Web Part”.

023-how-to-create-home-page-dashboards-in-sharepoint-2013

I’m going to bind the very top Web Part to the Under $50 view.

024-how-to-create-home-page-dashboards-in-sharepoint-2013

I’m going to change the appearance to say, “Under $50” to make sense to my users, and I’m going to click OK.

025-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to go to the next Web Part, the second Web Part down. See the top one’s bound to Under $50. I’m going to click the black triangle.

026-how-to-create-home-page-dashboards-in-sharepoint-2013

Click Edit Web Part.

027-how-to-create-home-page-dashboards-in-sharepoint-2013

I’m going to bind this Web Part to the $50 to $100 view.

028-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to click Check on Appearance, and I’m going to call this “$50 to $100.”

029-how-to-create-home-page-dashboards-in-sharepoint-2013

That should be fine, using dollar signs in that particular location.

Then finally I’m going to bind the third Web Part, at the very bottom, I’m going to bind that to over $100.

Again, select the black triangle, Edit Web Part.

030-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to click the drop down menu here to bind this Web Part to the over $100 view that I created in the other video.

031-how-to-create-home-page-dashboards-in-sharepoint-2013

Expand the appearance here and say “Over $100.”

032-how-to-create-home-page-dashboards-in-sharepoint-2013

Then I’m going to click OK, and I’m done.

As far as the dashboard’s going, I’m done. I’ve created my page.

033-how-to-create-home-page-dashboards-in-sharepoint-2013

I’ve now got a page that says ProductsByPrice, I’ve got under 50 bucks and it’s got a sub‑grouping by category, which is great. There’s $50 to $100, there’s over $100.

You may also like:  Part 2 - How to Import a CSV Text File into SharePoint 2013 - Preparing the Excel File

Now, these aren’t showing up in the navigation yet.

034-how-to-create-home-page-dashboards-in-sharepoint-2013

I can change that by clicking on Site Contents, opening up the site pages library.

035-how-to-create-home-page-dashboards-in-sharepoint-2013

Then click on Edit Links.

036-how-to-create-home-page-dashboards-in-sharepoint-2013

Now I can grab Products by Price there, and Products by Department. I’ll drag and drop it to just underneath there and click Save.

037-how-to-create-home-page-dashboards-in-sharepoint-2013

Now I’ve got navigation of Products by Price.

038-how-to-create-home-page-dashboards-in-sharepoint-2013

When you create a list by importing a spreadsheet ‑‑ I’ll click on Site Contents

039-how-to-create-home-page-dashboards-in-sharepoint-2013

The go to my Products list.

040-how-to-create-home-page-dashboards-in-sharepoint-2013

This is that list that we did a few videos ago. You’ll notice it doesn’t show up on the quick launch.

041-how-to-create-home-page-dashboards-in-sharepoint-2013

If you want it to, I could drag it over like I did out of the site contents page, but also what you could do is go to the actual list settings. I went to the List > List Settings and then List name, Description, and navigation.

042-how-to-create-home-page-dashboards-in-sharepoint-2013

There’s just a radio button that says, “Do you want to display it on the quick launch bar?” You most likely do, unless you have a reason not to.

043-how-to-create-home-page-dashboards-in-sharepoint-2013

Now I can see the products list. I can go to my ProductsByDepartment page.

044-how-to-create-home-page-dashboards-in-sharepoint-2013

I can go to my ProductsByPrice page, and in fact what I’m going to do is, I like this page so much, if I click the logo that takes me the home page of the site, I’m going to make my Products by Price page the home page of this site.

045-how-to-create-home-page-dashboards-in-sharepoint-2013

To do that, I’m going to go to the page, click on the Page tab, and then there’s actually an icon that says Make Home Page, which is awesome. I can click Make Home Page, click OK, and now this is the home page of this sub site.

046-how-to-create-home-page-dashboards-in-sharepoint-2013

If I scroll over here to Home, or click Home, or if I click that logo, or if I go back up to the top level site and then click the Products link, that is now the home page of my actual site.

047-how-to-create-home-page-dashboards-in-sharepoint-2013

That concludes our five‑part video series. No custom code, everything out of the box, starting with a simple CSV file, creating some dashboards, hooking up the navigation. Enjoy.

Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ

  1. Introduction
  2. Prepare the Excel File
  3. Create the List in SharePoint 2013
  4. Create the Views in SharePoint 2013
  5. Create the SharePoint Home Page Dashboard

Videos You May Like

Creating Users and Managing Passwords in Microsoft Office 365

0 168 1

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.

JavaScript for C# Developers – September 24, 2014

0 261 1

In this video Dan Wahlin demonstrate the similarities and differences between C# and JavaScript and the future of JavaScript (ES6).

Detailed Forensic Investigation of Malware Infections – April 21, 2015

2 271 3

In this IT Security training video, Security expert Mike Danseglio (CISSP / CEH) will perform several malware investigations including rootkits, botnets, viruses, and browser toolbars.

Write a Comment

See what people are saying...

  1. Pingback: Video Part 4 How to Create Views in SharePoint 2013 for import CSV file into SharePoint

Share your thoughts...

Please fill out the comment form below to post a reply.